From: | Michele Gius <mgius(at)pi(dot)be> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | SQLBrowseConnect: Invalid string or buffer length |
Date: | 2003-09-18 11:45:12 |
Message-ID: | 3F699AC8.3080000@pi.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
I am trying to get the SQLBrowseConnect function to work. I used
ODBCTest.exe from the MDAC SDK to check for results but I always get
messages like the following:
SQLBrowseConnect:
In: ConnectionHandle = 0x00761830,
InConnectionString =
"DSN=postgresql30", StringLength1 = 16, OutConnectionString = 0x000C8C18,
BufferLength = 300,
StringLength2Ptr = 0x000C2CD0
Return: SQL_ERROR=-1
Out: *OutConnectionString = <unmodified>,
*StringLength2Ptr = <unmodified>
dbc: szSqlState = "HY090", *pfNativeError = 0,
*pcbErrorMsg = 64
szErrorMsg = "[Microsoft][ODBC
Driver Manager] Invalid string or buffer length"
Input strings tried:
DSN=postgresql30
DSN=postgresql30;
Driver=PostgreSQL
Driver=PostgreSQL;
Driver={PostgreSQL}
Driver={PostgreSQL};
Where postgresql30 is a valid System DSN which I successfully use to
connect to the server with PGAdmin III
and PostgreSQL is the installed ODBC driver in version 7.03.01.00 . The
running backend is cygwin PostgreSQL 7.3.4.
The whole is running on Win2k with SP4 and MDAC 2.7 installed.
The ODBC 3 attribute has been set after acquiring the environment handle.
SQL_ATTR_ODBC_CURSORS=110 has been set to SQL_CUR_USE_ODBC=1 .
I would be really glad if someone had an idea what is wrong here.
Thanks in advance
Michele.
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2003-09-18 12:36:46 | Re: observations about temporary tables and schemas |
Previous Message | Hiroshi Inoue | 2003-09-18 03:45:17 | Re: Delphi7, ADO, ODBC and PostgreSQL connection problems |