Setting Up the Connection to the SQL Server

Use

If you want to use an MS SQL Server 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

You can start the ODBC Data Source Administrator from the start menu under Run odbcad32.exe .

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.

After the odbcad32.exe is started, the ODBC Data Source Administrator dialog box is displayed.
In the ODBC Data Source Administrator, click the System DSN tab.
Choose the Add pushbutton.

The Create New Data Source dialog box appears.
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.
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.
Choose Next.

A dialog box appears in which you enter the authentication data.
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.
Select the option Change Default Database to: and choose the PCODB entry. Choose Next.
In the following dialog box, you can apply the settings. Then choose Finish.

The ODBC Microsoft Server Set Up dialog box appears.
Choose the Test Connection pushbutton.

If the connection can be established, a success message is issued.
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.