Versions Compared

Old Version 3

changes.mady.by.user Aryn Wiebe

Saved on

compared with

New Version Current

changes.mady.by.user Aryn Wiebe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleSTEP 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.

Image RemovedImage Added

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.

Expand
titleSTEP 4: Confirm IguanaX has detected the ODBC library in Settings > Database

In IguanaX, Settings > Database confirm the ODBC library has been detected and loaded correctly.

If not, click Edit to manually add the ODBC shared library path. If you don’t know the location, you can search for the odbc32.dll

Image Added