Kbase P99741: SQLState=S1000, NativeError=30033 with Progress ODBC driver on Unix .
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/11/2005 |
|
Status: Unverified
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Getting Merant error when connecting to database from application.
The MERANT 3.6 ODBC driver generates native error# 30033.
Setting up and testing the Progress ODBC driver on UNIX.
Service Pack 09 for Progress 9.1D is also installed on the machine.
Database is up and running in client/server mode (-S).
The ODBCINI environment variable is properly set pointing to the correct odbc.ini file. e.g.: ODBCINI=$DLC/odbc/odbc.ini; export ODBCINI
The LD_LIBRARY_PATH environment variable is also set properly and includes the correct directories. e.g.: LD_LIBRARY_PATH=$DLC/odbc/lib:$DLC/lib; export LD_LIBRARY_PATH
Attempting to execute the sample demoodbc.c file to demonstrate some of the ODBC function calls used to fetch some simple data from a Progress SQL-92 database.
SQLConnect: Failed...
SQLSTATE = HY000
NATIVE ERROR = 30033
MSG =
NATIVE ERROR=No Packet received.
ODBC stack trace contains errors.
Return code 100 (SQL_NO_DATA_FOUND)
[DataDirect-Technologies][ODBC PROGRESS || driver]Error parsing connect string at o |
CAUSE:
Connection string contained
FIX:
Change the port number in the odbc.ini file to match the port number for the SQL-92 Broker.