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
.
You can start the ODBC Data Source Administrator
from the start menu under .
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
.