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

« Previous Version 3 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.

  1. Open the System DSN tab and click Add.

  1. Choose the latest SQL Server ODBC driver and click Finish.

  1. Enter the ODBC credentials:

    • Use any Name and Description you prefer.

    • Enter the Network Name of the SQL Server in the Server field:

    • Click Finish to create the ODBC data source.

 STEP 3: Test the data source connection

Once the data source is created, the ODBC Microsoft SQL Server Setup window opens to list the chosen settings. The ODBC source will use all the standard defaults which will work in most cases. Click Test Data Source to test the connection.

If unsuccessful, you may need to speak to your DBA (database administrator) about changing these if necessary. To make changes, go to the ODBC Data Source Administrator and click Configure.

There are a few settings that you may need to change:

  1. Integrated Security (default): Sometimes you might want to use a SQL Server user and password instead of the default Integrated Security to connect to a Microsoft SQL Server 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.

  • No labels