SQLBrowseConnect: Invalid string or buffer length

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.

Responses

Browse pgsql-odbc by date

  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