Database Connection Strings

<< Click to Display Table of Contents >>

Navigation:  Advanced >

Database Connection Strings

All ThinkAutomation Database Actions require you to specify a 'Connection String'. This provides ThinkAutomation with the information needed to connect to your database.

 

Connection Strings differ from database type to database type.

 

You can manually specify the connection string by entering it directly, or you can use the Build button to show the Data Link Properties form. This is used to build a connection string which is then passed back to the Connection String entry:

 

datalink1

 

The first tab shows all the available database sources on your computer. Select the data source and click Next. For example: For SQL Server 2008/2012 select SQL Server Native Client 11.0. If this is not listed you need to install the SQL Server client (this is normally part of the SQL Server setup - however if you are on a remote computer you will need to install the SQL Server client).

 

datalink2

 

You must then select the server name for the computer running the database. Click the dropdown menu to view a list.

 

You then need to provide the authentication settings, either Windows Integrated Security or Use a specific user name and password. If you do specify a user name/password ensure you enable the Allow saving password option - this will ensure the password is passed back to the connection string.

 

You then need to Select the database you wish to connect to.

 

Click Test Connection to verify the database can be opened using the details you have provided.

 

Click OK to save the connection string back to the entry you are using. You can adjust the connection string if required:

 

Provider=SQLNCLI11.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=IM4Teams;Data Source=(local);Initial File Name="";Server SPN=""

 

 

Using Field Replacements Or Constants For Connection Strings

You can use %field% replacements for connection strings. You can also use global constants. Using constants helps when you need to use the same connection string in lots of places. First build your connection string and make sure it works. Then use the Organizations form on the program options form to create a global 'constant' to hold the connection string value. You can then use this constant in the form %ConstantName% in your connection string entries.

 

 

More Information

For more information about connection strings see:

 

http://www.connectionstrings.com/ - a reference for connection string formats for most database types.

http://en.wikipedia.org/wiki/Connection_string

 

Online generator for SQL Server connection string:

http://www.developerfusion.com/tools/sql-connection-string/

 

 

 

 

 

 

ThinkAutomation © Parker Software 2016