Hexagon Geospatial
MENU

Spatial Modeler

Discuss topics with other Hexagon Geospatial Product pioneers and experts to get the most out of our products.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Regular Visitor
Posts: 1
Registered: ‎01-07-2019

Spatial Modeler: SQL DB connection string

Hello,

 

I am using Spatial Model Editor Version 16.5.0.

I am trying to use the Features Database Output operator.

I can create a database connection to SQL server and I get a list of available tables. But when I look at the properties of the operator, the connection string ends after 255 characters.

When I try to run the model, I get an error on the connection string (unexpected end).

 

String in the properties (only 255 chars): 

DB||<dsSmiley Very HappyataSourceMoniker xmlns:ds='http://www.intergraph.com/geoprocessing/ds' version='1.0' type='SQL Server'><ConnectionString ForwardOnly='True'>Server=XXXXXACCL;Database=DataXXXXXXXXX;Integrated Security=True</ConnectionString><Feature></Feature><Fie

 

What it should be:

DB||<dsSmiley Very HappyataSourceMoniker xmlns:ds='http://www.intergraph.com/geoprocessing/ds' version='1.0' type='SQL Server'><ConnectionString ForwardOnly='True'>Server=XXXXXACCL;Database=DataXXXXXXXXX;Integrated Security=True</ConnectionString><Feature></Feature><FieldType>51</FieldType><Filter></Filter><CommandTimeout>120</CommandTimeout></dsSmiley Very HappyataSourceMoniker> 

 

Changing the field by hand does not solve the problem, the maximal lenght of the operator is 255 chars.

Staff
Posts: 83
Registered: ‎06-30-2016

Re: Spatial Modeler: SQL DB connection string

What is the error message you get when running the model?

You can see the error message in the session log (File -> Session -> View Session log)

 

Regards. Sam 

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.