Re: SQLBrowseConnect: Invalid string or buffer length - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: SQLBrowseConnect: Invalid string or buffer length
Date
Msg-id 3F6A421F.B6B6B723@tpf.co.jp
Whole thread Raw
In response to SQLBrowseConnect: Invalid string or buffer length  (Michele Gius <mgius@pi.be>)
Responses Re: SQLBrowseConnect: Invalid string or buffer length
List 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

pgsql-odbc by date:

Previous
From: Richard Combs
Date:
Subject: Re: Delphi7, ADO, ODBC and PostgreSQL connection problems:
Next
From: Hiroshi Inoue
Date:
Subject: Re: [HACKERS] Killing the backend to cancel a long waiting query