Kbase P10056: Trying to establish SQL 89 connection to database on AIX box
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/01/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FACT(s) (Environment):
IBM AIX 4.3.3
FACT(s) (Environment):
MERANT 3.70 32-BIT Progress SQL-89
FACT(s) (Environment):
Progress 8.3E
FACT(s) (Environment):
Progress 8.3B
SYMPTOM(s):
ODBC connection to database fails.
Receives a Windows Warning message that only contains a Exclamation point.
The environment variables have been set in the Autoexec.bat file correctly.
DLC=c:\DLC;
IDLC=c:\DLC;
PROMSGS=c:\DLC\promsgs;
IPROMSGS=c:\DLC\promsgs;
Unix database environment is setup as
PROMSGS=/usr/dlc/promsgs
PROOIBRK=/usr/dlc/bin/_prooibk
PROOIDRV=/usr/dlc/bin/_prooidv
DLC=/usr/dlc
IDLC=/usr/dlc
IPROMSGS=/usr/dlc/promsgs
Esql32.dll file copied into the WINNT\SYSTEM32 directory and renamed it prosql32.dll.
Event log shows no errors.
Connection can be established to Database via Data Dictionary.
Telnet hostname portnumber. Responded correctly.
Nestat -a |more on Unix box shows the Oibroker port as listened.
Exported the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MERANT 3.70 32-BIT PROGRESS key and compared with a working key. Keys are identical
Review of the proidrv.lg file
OIDRVR server is spawned. (1892)
OIDRVR 0: Shutdown Open Interface Driver id: 47160. (2582)
Database log file does not indicate any connection attempt.
Enabled ODBC tracing under the tracing tabe of the ODBC Data Source Administartor. ODBC LOG shows the following message
dbcad32 4a0-5cc EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 00811520
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER -6
Applied latest service pack to Windows machine.
Attempt another test connect to database.
PROGRESS error returned with no associated message: RC = -1; SQLCODE = -1;
SQLSTATE = "".
FIX:
To workaround the issue the OIBroker was started on another machine other then the AIX box. To start a oibroker to remotely connect to a database, follows the steps outlined in How to setup SQL-89 using oibroker.
Solution ID:17204 Solution