Tutorial: Create an ODBC 32-bit System Connection

  1. Start the 32-bit ODBC Data Source Administrator. If you need instructions, see To start the ODBC Data Source Administrator.
  2. Click the System DSN tab.
  3. Click Add.
  4. On the Name list, select SQL Server; then click Finish.
  5. On the Create a new Data Source to SQL Server page, type SQLCLRTutorial into the Name field. This is the data source name.
  6. In the Server field, type . (dot) to represent your local server; then click Next.

    Here, you can optionally change the default authentication method from Windows authentication to SQL Server authentication.

  7. To change the authentication method, click With SQL Server authentication.... (Optional)
  8. Click Next.
  9. Check Change the default database to; then type SQLCLR_Test into the accompanying field.
  10. Click Next, then Finish.
  11. On the ODBC Microsoft SQL Server Setup page, click Test Data Source.
  12. Once the tests complete successfully, click OK to exit.
  13. Click OK to close the ODBC Data Source Administrator.
Parent topic: Prerequisites
Parent topic: Prerequisites
Related tasks
To start the ODBC Data Source Administrator