ODBC and Large Objects, FAQ not working
От | Christian Hang |
---|---|
Тема | ODBC and Large Objects, FAQ not working |
Дата | |
Msg-id | 199912072157.WAA21139@kawoserv.kawo2.rwth-aachen.de обсуждение исходный текст |
Список | pgsql-interfaces |
Hi, I know you've read this all before, as I went through most postings concerning this issue. But I haven't found a reply that helped me, so I hope I'll get one this way. I want to hook up Microsoft Access (2000) via ODBC (6.400007) to my PostgreSQL server (6.5.3, Linux 2.2.10). Everything works fine, but I am having trouble inserting OLE objects into my database. I created the "lo" type suggested in the ODBC FAQ and a basic table (CREATE TABLE ole (id int4, bild lo);) for testing purposes. But when I insert an OLE object, I get the error message "Couldnt open large object for writing (ERROR #1)". I attached the corresponding log. I'd appreciate your help in this matter, as I tried any advice given in earlier postings concerning problems like this, but nothing would help. Chris ---- Error log: conn=144654652, query='BEGIN' conn=144654652, query='INSERT INTO "ole" ("id") VALUES (1)' conn=144654652, query='COMMIT' conn=144654652, query='SELECT "oid","id","bild" FROM "ole" WHERE "oid" IS NULL' [ fetched 0 rows ] conn=144654652, query='SELECT "ole"."oid" FROM "ole" WHERE "id" = 1' [ fetched 1 rows ] conn=144654652, query='SELECT "oid","id","bild" FROM "ole" WHERE "oid" = 19718' [ fetched 1 rows ] conn=144654652, query='SELECT "oid","id","bild" FROM "ole" WHERE "oid" = 19718' [ fetched 1 rows ] conn=144654652, query='SELECT "oid","id","bild" FROM "ole" WHERE "oid" = 19718' [ fetched 1 rows ] ERROR from backend during send_function: 'ERROR: lo_lseek: invalid large obj descriptor (0) ' STATEMENT ERROR: func=SQLPutData, desc='', errnum=1, errmsg='Couldnt open large object for writing.' ------------------------------------------------------------ hdbc=144654652,stmt=144669180, result=0 manual_result=0, prepare=0, internal=0 bindings=0,bindings_allocated=0 parameters=145688992, parameters_allocated=1 statement_type=1,statement='INSERT INTO "ole" ("bild") VALUES (?)' stmt_with_params='INSERT INTO "ole" ("id") VALUES (1)' data_at_exec=0, current_exec_param=0, put_data=1 currTuple=-1, current_col=-1,lobj_fd=-1 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 cursor_name='SQL_CUR089F79FC' ----------------QResult Info ------------------------------- CONN ERROR: func=SQLPutData, desc='', errnum=0, errmsg='ERROR: lo_lseek: invalid large obj descriptor (0) ' ------------------------------------------------------------ henv=145686660, conn=144654652, status=1,num_stmts=16 sock=145688632, stmts=145688672, lobj_type=19268 ---------------- Socket Info ------------------------------- socket=308, reverse=0, errornumber=0, errormsg='(null)' buffer_in=144660980,buffer_out=144665080 buffer_filled_in=53, buffer_filled_out=0, buffer_read_in=53 ERROR from backend during send_function: 'ERROR: lo_lseek: invalid large obj descriptor (0) ' STATEMENT ERROR: func=SQLPutData, desc='', errnum=1, errmsg='Couldnt open large object for writing.' ------------------------------------------------------------ hdbc=144654652,stmt=144669180, result=0 manual_result=0, prepare=0, internal=0 bindings=0,bindings_allocated=0 parameters=145688992, parameters_allocated=1 statement_type=1,statement='INSERT INTO "ole" ("bild") VALUES (?)' stmt_with_params='INSERT INTO "ole" ("id") VALUES (1)' data_at_exec=0, current_exec_param=0, put_data=1 currTuple=-1, current_col=-1,lobj_fd=-1 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 cursor_name='SQL_CUR089F79FC' ----------------QResult Info ------------------------------- CONN ERROR: func=SQLPutData, desc='', errnum=0, errmsg='ERROR: lo_lseek: invalid large obj descriptor (0) ' ------------------------------------------------------------ henv=145686660, conn=144654652, status=1,num_stmts=16 sock=145688632, stmts=145688672, lobj_type=19268 ---------------- Socket Info ------------------------------- socket=308, reverse=0, errornumber=0, errormsg='(null)' buffer_in=144660980,buffer_out=144665080 buffer_filled_in=53, buffer_filled_out=0, buffer_read_in=53 conn=144654652, SQLDisconnect
В списке pgsql-interfaces по дате отправления: