Show TOC

Background documentationSetting Up the Connection to the SQL Server

 

If you want to use an MS SQL Server 2008 as an ODBC destination system, you first need to create and configure the ODBC connection to this server using the ODBC Data Source Administrator before you can create the ODBC destination system in the PCo Management Console. To do so, you need to create a Data Source Name (DSN) for the SQL server in the ODBC Data Source Administrator.

Procedure

  1. You can start the ODBC Data Source Administrator from the start menu under Start of the navigation path Run Next navigation step odbcad32.exe End of the navigation path.

    Note Note

    If you are using a 64-bit version of Windows, you must ensure that you are using the ODBC Data Source Administrator in the 32-bit version. A 32-bit version and a 64-bit version of the ODBC Data Source Administrator are available in the 64-bit version of Windows7. In this Windows version, you start the 64-bit version of the ODBC Data Source Administrator from the start menu by choosing Run. The System Data Source Name entries that are created using the 64-bit version are not taken into account by PCo, however.

    The valid 32-bit version is located in the subfolder SysWOW64 in the Windows directory; for example, under C:\Windows\SysWOW64\odbcad32.exe.

    If you create User Data Source Name entries instead of System Data Source Name entries, you can also use the 64-bit version of the ODBC Data Source Administrator.

    End of the note.

    After the odbcad32.exe is started, the ODBC Data Source Administrator dialog box is displayed.

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

  3. Choose the Add pushbutton.

    The Create New Data Source dialog box appears.

  4. Choose the entry SQL Server from the list of drivers. Then choose Finish.

    The Create a New Data Source to SQL Server dialog box is displayed.

  5. Enter the following data:

    • Name

      Here you can enter a name of your choice for the SQL server that is then used as the ODBC data source. This name is then displayed later in PCo on the Configuration tab of the ODBC destination system.

    • Description

      You can enter a short description here.

    • Server

      You enter servers in the Server field, for example, vmwxxxx.

  6. Choose Next.

    A dialog box appears in which you enter the authentication data.

  7. Enter the logon data, if necessary. Then choose the Client Configuration pushbutton and enter the number of the port in the next dialog box and choose Next.

    The dialog box appears in which you can specify the default database.

  8. Select the option Change Default Database to: and choose the PCODB entry. Choose Next.

  9. In the following dialog box, you can apply the settings. Then choose Finish.

    The ODBC Microsoft Server Set Up dialog box appears.

  10. Choose the Test Connection pushbutton.

    If the connection can be established, a success message is issued.

  11. Confirm by choosing OK.

    The SQL server is then displayed on the System DSN tab and can be selected on the Configuration tab in the PCo Management Console.