ODBC data source setup for Microsoft SQL Server

About this task

In these steps you create an ODBC data source that is used by a Windows-based Management Console to access the database you created in Microsoft SQL Server. You must create a 32-bit ODBC data source regardless of whether you are running a 32-bit Windows system or a 64-bit Windows system.

Procedure

  1. Start the Data Source Administrator.
    • For 32-bit Windows systems: From the Windows start menu, select Settings > Control Panel > Administrative Tools > Data Sources.
    • For 64-bit Windows systems: double-click the file C:\Windows\SysWOW64\odbcad32.exe.
    The Data Source Administrator dialog box is displayed so that you can create the required 32-bit ODBC data source on the 64-bit system.
  2. On the System DSN tab, click Add. A list of drivers appears.
  3. Select MS SQL Server from the list of drivers, then click Finish. In the ODBC Setup dialog box that appears, enter the following information:
    • Data Source Name: the name for this data source, must be the same as Database Name and must not be the same as the schema name associated with the database.
    • Description: description for this data source.
    • Server Name: host name of the host where the MS SQL Server database is installed.
    • Database Name: database name you created above.

    Click OK to close ODBC Setup, then OK to close ODBC Data Source Administrator. The data source is created.

Results

Make a note of the following information. It is requested by the installation program when you install the Management Console.
Important: Use the same value for the Database Name and Data Source Name. A limitation in JDBC drivers requires this constraint. If they are not the same, the Quick Report reporting feature and the services-layer APIs for Java and Perl do not work.

Feedback