Create an ODBC 32-bit System Connection

Walks you through the process of creating an ODBC connection to use when completing these tutorials.
  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 the ODBC driver version recommended for your version of Microsoft SQL Server.
    Note: For a list of supported Microsoft SQL Server versions, see the Relational Database Management Systems (RDBMSs) section in the Supported Operating Systems and Third-party Software topic.
  5. Click Finish.
  6. On the Create a new Data Source to SQL Server page, type SQLCLRTutorial into the Name field. This is the data source name.
  7. 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.

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