Page Comparison

If you wish to create a Workflow Connections to a Microsoft SQL Server database then you will first need to edit the ConTypes.xml file to add the SQL Server MSSQLServer Connection Type (if this has not already been done). You will find the file in the ...Astun\iShare\n.n\Studio\config folder.

If you open ConTypes.xml with a text editor you will see options for DBConType (servers, connection types such as PostgreSQL, SDE, Oracle and OracleWFS) and FileConTypes (file formats such as shapefile or mapinfo tab).

...

<DBConType>
  <Name>MSSQLServer</Name>
  <FormatName>MSSQL</FormatName>
  <Server>Yes</Server>
  <Database>Yes</Database>
  <Username>Yes</Username>
  <Password>Yes</Password>
  <Port>Yes</Port>
  <Direction>Both</Direction>
  <FormatStr>MSSQL:"server=|$1|,|$6|;database=|$3|;UID=|$4|;Pwd=|$5|;Persist Security Info=True"</FormatStr>
</DBConType>

...

Now if you right click on the Connections node under Workflow in the tree and select New Connection you should see your new entry for MSSQLServer.

Image Added

Select the radio button for MSSQLServer and you will be prompted to enter your connection details e.g.

Connection

Name

This is the unique name that you wish to give your database connection. It is advisable to call is something relevant as this name will be used to populate list box selections when creating Tasks.

Server

This is the name / IP address of the server where the database resides.

Instance

This is not required for a SQL Server connection.

Database

This is the actual name of the database.

Port

The port number being used.

Username

This is the Username for the Workflow to access the database.

Password

This is the password for the above Username.

...