Обсуждение: SQLBrowseConnect: Invalid string or buffer length
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.
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
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 >> >> > > >