Re: Bug report 2267: Accessing large objects via ODBC
| От | Gerhard.Lutz@mbtech-group.com |
|---|---|
| Тема | Re: Bug report 2267: Accessing large objects via ODBC |
| Дата | |
| Msg-id | OF458F3461.9CD9B4ED-ONC1257123.00509389-C1257123.0051AE57@dcx.dcx обсуждение исходный текст |
| Ответ на | Re: Bug report 2267: Accessing large objects via ODBC (Ludek Finstrle <luf@pzkagis.cz>) |
| Список | pgsql-odbc |
The version of PSQLODBC.DLL is 8.01.02.00.
In version 8.00.01.03 I didn't have this problem.
I didn't create the lo type explicitly. I just checked the checkbox "Large Objects (lo)"
while installing PostgreSQL. This worked with PostgreSQL 8.0.4.
I didn't find a special psqlODBC FAQ, only the general FAQ lists at www.postgresql.org.
Best regards,
Gerhard Lutz
| luf@pzkagis.cz Gesendet von: pgsql-odbc-owner@postgresql.org 27.02.2006 14:24 |
|
> I want to upgrade my PostgreSQL server from 8.0.4 to 8.1.3.
> My C++ application connects to the database via ODBC (ODBC driver: PostgreSQL Unicode).
>
> I've installed 8.1.3 with "large objects (lo)" and created a table
>
> CREATE testdata
> (id integer not null,
> buffer lo);
>
> So far this worked.
> Now if I want to get the 'buffer' column
>
> ::SQLExecDirect(m_hStmt, (unsigned char*)"SELECT buffer FROM testdata WHERE id=6", SQL_NTS);
> ::SQLFetch(m_hStmt);
> ::SQLGetData(m_hStmt, nCol, SQL_C_BINARY, pBuffer, nPacketSize,
> &sdODataLength);
>
> I get the error message
>
> "Received an unsupported type from Postgres. (14)"
>
> In PostgreSQL 8.0.4 this worked without a problem.
> In 8.1.3 I can also see in pgAdmin III that there are no functions
> lo_in(lo) and lo_out(lo) in the tree.
>
> Perhaps this is an installation bug in 8.1.3?
> Has anybody got an idea?
I see no psqlODBC version in your report.
How did you create the lo type? Did you follow psqlODBC FAQ?
Regards,
Luf
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
В списке pgsql-odbc по дате отправления: