Setup ODBC DSN

This topic continues our discussion of the ODBC DSN setup for Crystal Reports that began in Setup ODBC DSN for Crystal Reports.

In order to create a new ODBC data source name, you will need to start ODBC Data Source Administrator.

64-Bit Operating Systems

For 64-bit operating systems, you must start ODBC Data Source Administrator from the C:\Windows\SysWOW64 folder. Use the following steps to start the application.

1. Browse to the C:\Windows\SysWOW64 folder.
2. Double-click odbcad32.exe.

32-Bit Operating Systems

For 32-bit operating systems, you must start ODBC Data Source Administrator from the C:\Windows\system32 folder. Use the following steps to start the application.

1. Browse to the C:\Windows\system32 folder.
2. Double-click odbcad32.exe.

Configure ODBC Data Source Administrator

Use the following steps to add a new data source name using ODBC Data Source Administrator.

1. In ODBC Data Source Administrator, click the System DSN tab.
2. Click Add.

3. In Create New Data Source, select SQL Server Native Client 10.0.
4. Click Finish.

5. In Create a New Data Source to SQL Server, enter the following information.
   1. Name – name of the data source
   2. Description – description of the data source
   3. Server –name of the SQL server, click to select a server from the list.
6. Click Next.

7. Select With SQL Server authentication using a login ID and password entered by the user.
8. Enter the logon information to connect to the SQL server.
   1. Login ID
   2. Password
9. Verify that Connect to SQL Server to obtain default settings for the additional configuration options is selected.
10. Click Next.

11. Click Next on the two screens that follow in the wizard . Make no changes.

12. Click Test Data Source to test the connection.

13. Click OK and exit the wizard.

See Also