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 MSSQLServer Connection Type (if this has not already been done). You will find the file in the ...Astun\iShare\n.n\Studio\config folder.

...

Create a new DBConType entry after the last closing</DBConType> tag (but before the closing </ConnectionTypes> tag as follows:

<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>

...

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.

...