Re: SQLBrowseConnect: Invalid string or buffer length

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Michele Gius <mgius(at)pi(dot)be>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: SQLBrowseConnect: Invalid string or buffer length
Date: 2003-09-18 23:39:11
Message-ID: 3F6A421F.B6B6B723@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

SQLBrowseConnect isn't implemented yet, sorry.

regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/

Michele Gius wrote:
>
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-09-18 23:46:13 Re: [HACKERS] Killing the backend to cancel a long waiting query
Previous Message Richard Combs 2003-09-18 20:29:38 Re: Delphi7, ADO, ODBC and PostgreSQL connection problems: