Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

How to set up a new ODBC data source for Microsoft SQL Server on Windows:

 STEP 1: Install the latest Microsoft SQL Server ODBC drivers

  1. Download the latest drivers from the Microsoft ODBC download site.

  2. Run the installer and accept the defaults.

Iguana may not always support the very latest version of the Microsoft SQL Server ODBC drivers, so you can simply download an earlier version if necessary. This is particularly true if you are not able to use the the latest version of Iguana.

If you need to know which versions of Microsoft SQL Server are supported by the version of Iguana you are using please contact us at support@interfaceware.com.

 STEP 2: Use the 64 bit ODBC Administrator to create the ODBC data source

  1. On your Windows machine, search “ODBC” to find ODBC Data Sources (64 bit). Right Click and choose Run as Administrator to open the ODBC Data Source Administrator.

  2. Open the System DSN tab and click Add. Choose the latest SQL Server ODBC driver and click Finish.

odbc system dsnlatest ODBC driver

  1. Enter the ODBC credentials:

    • Use any Name and Description you prefer.

    • Enter the Network Name of the SQL Server in the Server field:
      Note: If you are unsure of the name ask your DBA (database administrator).

    • Click Finish to create the ODBC data source.

ODBC credentials
 STEP 3: Confirm or change your ODBC default settings

This will open the ODBC Microsoft SQL Server Setup window which lists the chosen settings. The ODBC source will use all the standard defaults which will work in most cases.

Speak to your DBA (database administrator) about changing these if necessary. There are a few settings that you may need to change:

  1. User login/Integrated Security: Sometimes you might want to use a SQL Server user and password. Using integrated security is the usual way to connect to a Microsoft SQL Server database. If this does not work speak to your DBA (database administrator) about the user credentials you should use to connect to the database. To change to a user login, select SQL Server Authentication, enter User and Password.

  2. Database: You can specify the database that you want to use by default.

  3. Incorrect port number: SQL Server defaults to port 1433, but a different port can be used. Speak to your database administrator (DBA) or network administrator.

 STEP 4: Test the data source connection

  1. Click Test Data Source…:

  2. And if it works you are finished:

  3. If it does not work speak to your DBA about how to login to the database (user authentication).

ODBC propertiesdata source works

  • No labels