Please, follow the next steps to specify the ODBC connection:

• Please go to the “ODBC Administrator” choose the TAB “System DSN” and click “Add”. Choose the appropriate SQL Server Driver. See the picture:

Click “Finish”

• In appeared window please enter the name of your future data source and in drop-down menu select server which you want to connect to as illustrated on the screen-shot below:

Click “Next”

• Please choose authentication method and if necessary enter login and password.

Click “Next”

• On this step you can change default database or attach database file if you want.

Click “Next”

• Click “Finish”

• Please press “Test Data Sourse” to test connection and if it's successful press “OK”

Now your ODBC Data Source is ready.

After that please restart the SQLWays Wizard tool and you will see the ODBC connection in the “User\System DSN” drop down option.

Please, follow the next steps to specify the ODBC connection:

• Please go to the “ODBC Administrator” choose the TAB “System DSN” and click “Add”. Choose the appropriate SQL Server Driver. See the picture:

Click “Finish”

The following steps are identical to the same for SQL Server 2000 (See above)

After that please restart the SQLWays Wizard tool and you will see the ODBC connection in the “User\System DSN” drop down option.

Please, follow the next steps to specify the ODBC connection:

• Please go to the “ODBC Administrator” choose the TAB “System DSN” and click “Add”. Choose the appropriate SQL Server Driver. See the picture:

Click “Finish”

The following steps are identical to the same for SQL Server 2000 (See above)

After that please restart the SQLWays Wizard tool and you will see the ODBC connection in the “User\System DSN” drop down option.

Please, follow the next steps to specify the ODBC connection:

• Please go to the “ODBC Administrator” choose the TAB “System DSN” and click “Add”:

• Choose the appropriate SQL Server Driver and click “Finish”:

• In appeared window please enter the name of your future data source and in drop-down menu select server which you want to connect to or specify it manually as illustrated on the screen-shot below:

Click “Next”

• Please choose SQL Server authentication method and enter login and password.

Click “Next”

• On this step you need to specify the default database that you want to connect or attach database file if you want.

Click “Next”

• Click “Finish”

• Please press “Test Data Sourse” to test connection

• And if it's successful press “OK”

Now your ODBC Data Source is ready.

After that please restart the SQLWays Wizard tool and you will see the ODBC connection in the “User\System DSN” drop down option.

To tune the ODBC connection for Microsoft SQL Server 2014 please follow the instructions described in SQL Server 2012 block. All the steps are the same.

To tune the ODBC connection for Microsoft SQL Server 2016 please follow the instructions described in SQL Server 2012 block. All the steps are the same.

If you will have any questions or face with some difficulties please contact us: support@ispirer.com