From: | Michele Gius <mgius(at)pi(dot)be> |
---|---|
To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: SQLBrowseConnect: Invalid string or buffer length |
Date: | 2003-09-19 07:22:37 |
Message-ID: | 3F6AAEBD.9080901@pi.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
>>
>>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2003-09-19 10:12:41 | Re: Delphi7, ADO, ODBC and PostgreSQL connection problems: |
Previous Message | Noel R. Villamor | 2003-09-19 00:07:55 | Re: Delphi7, ADO, ODBC and PostgreSQL connection problems: SUCCESS! |