Creating an ODBC Connection (Microsoft SQL Server)

On your local computer, go to “Control Panel > System and Security > Administrative Tools”.
On 64-bit versions of Windows, you will see two (2) icons: ODBC Data Sources (32-bit) and ODBC Data Sources (64-bit).

Click on the “Add” button to create an ODBC connection:

odbc data source administrator

Select the Microsoft SQL Server Driver from the list and click on “Finish”.

Microsoft SQL Server ODBC driver

Enter the connection information:

Microsoft SQL Server ODBC configuration

Data Source Name must be “SIW”

Microsoft SQL Server ODBC configuration

Microsoft SQL Server ODBC configuration

Microsoft SQL Server ODBC configuration

Click the “Finish” button and click the “Test Data Source” button to ensure the connection is successful.

Microsoft SQL Server ODBC configuration

Click on “OK” when you’re done.

Microsoft SQL Server ODBC configuration

You should now be able to use this ODBC connection within your software applications (including SIW).