How to create an ODBC connection to a database

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

An ODBC (Open Database Connectivity) connection is a simple connection to a database. This connection can be used by any application that is ODBC compliant to access the data. The connection will work without regard to type of database, or application trying to access data. In working with Thomson Reuters software the two most common ODBC connections are MS SQL, and MS Access. There are many other types of connections possible.

There are a couple of reasons to utilize an ODBC connection.

To establish an MS SQL ODBC connection:

Be sure you are working from the computer that needs the connection

  1. Open the Control Panel, and click on Administrative Tools
  2. Open Data Sources (ODBC)
  3. Click on the System DSN tab
  4. Click Add, select SQL Server from the list, click Finish
  5. Type a Name, and Description for the connection - Be descriptive if this is going to be used for more than testing
  6. Select the SQL server the database resides on and click next

The next screen prompts you to enter how SQL server will verify the authenticity of the login. The default is Windows NT authentication, and this should be adequate in almost all circumstances.

If you are unable to connect, and know a valid SQL login you can revisit this and change the authentication method.

Once you have selected an authentication method click next.

For information on some common causes of connection issues with a particular application, click the appropriate link below:

Share This