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)


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: March 20, 2013, 04:15:42 AM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement