Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

Microsoft SQL Server ODBC Driver Configuration

Microsoft SQL Server 2000

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.

Microsoft SQL Server 2005

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)

Microsoft SQL Server 2008

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)

Microsoft SQL Server 2012

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

Microsoft SQL Server 2014

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.

Microsoft SQL Server 2016

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

sqlways/users-guide/setting-up-database-connection/sql-server/driver.txt · Last modified: May 07, 2018, 03:15:36 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement