Postgres Pro
Downloads
Home   >   mailing lists

Thread: SQLBrowseConnect: Invalid string or buffer length

SQLBrowseConnect: Invalid string or buffer length

From
Michele Gius
Date:
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.

Re: SQLBrowseConnect: Invalid string or buffer length

From
Hiroshi Inoue
Date:
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

Re: SQLBrowseConnect: Invalid string or buffer length

From
Michele Gius
Date:
I guess I should have looked up the source and its documentation before.
Instead I just issued a SQLGetFunctions which returned among others

SQL_API_SQLBROWSECONNECT = 55 SQL_TRUE

Thank you for your answer and above all thanks to you and the team for
this great driver.
It really works very well..

Regards,
Michele.

Hiroshi Inoue wrote:

>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
>>
>>
>
>
>