Kbase P112104: How to connect a Progress Client on UNIX with and ODBC DataServer.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2009 |
|
Status: Verified
GOAL:
How to connect a Progress Client on UNIX with and ODBC DataServer.
GOAL:
How to create an ODBC DataServer schema holder in UNIX ?
FACT(s) (Environment):
ODBC DataServer
UNIX
Progress 9.x
OpenEdge 10.x
FIX:
ODBC DataServers can only be installed on Windows, these are the requirements to access the ODBC DataServer in client/server mode.
On the Windows Server:
______________________
1) Set the following environment variable (in the control panel -> click on the System icon -> Advanced -> Environment variables) :
ODBSRV=%DLC%\bin\_odbsrv.exe
2) Start a broker like this from Proenv:
_probrkr -S <service name> -H <Windows host name> -N TCP
3) Make sure you can query the ODBC tables with your user and password using MS-Access or WinSQL (freeware) utility.
4) Verify that the port designated for the _probrkr is listening by issuing the command:
netstat -na
In the UNIX server:
_________________
5) Test the connectivity with the ODBC Data Server broker on the Windows server using the telnet command like this:
telnet <<Windows Host Name> <service name>
It must show a connected message, meaning that the broker is listening, then discard the telnet session.
6) Create an schema holder using the command:
prodb <holder name> empty
7) Start a Progress session
pro <holder name> -p dict.p
7) Go to the DataServer menu and choose
ODBC Utilities > Create DataServer Schema...
8) Connect with the ODBC DSN through _probrkr
Here is the UNIX screen:
________Create/Modify Database Record for DataServer Schema________
| Logical Database Name: <Source DB name or logical name>
| Server Type: ODBC
| Code Page: iso8859-1
| Collation: Basic
|
|  .;
|
| Connection Parameters:
|
| -S <service name> -H <Windows Host Name> -U <ODBC DB User> -P <ODBC DB password>
|
|
|
|
| ODBC Data Source Name:
| <Data Source Name>
| <OK> <Cancel> &.nbsp;
| _______________________________________________________________
Example:
Logical Database Name: odbcsales
Connection Parameters:
-S serbrk -H pcwindow1 -U ronda -P secret
ODBC Data Source Name:
DSNInformix
9) You will be prompted again for the user and password for the ODBC source DB, ignore it and just press the <OK> button.
10) Select the required ODBC tables
11) Once all the definitions are pulled from ODBC, the schema holder will be ready.
12) To connect to it, following the previous example type:
pro holder -RO -db DSNInformix -ld odbcsales -dt ODBC -S serbrk -H pcwindow1.