ODBC experts needed!

From: "Andrea Aime" <aaime(at)comune(dot)modena(dot)it>
To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: ODBC experts needed!
Date: 2001-01-05 10:24:35
Message-ID: 3A55A0E3.9BE7CC61@comune.modena.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I'm using Postgres as DBMS to store some data tables attached to
Autocad Map drawings (maps). I've got some problems: if I try
to look at the attached table I got a strange error, here is
the odbc-driver log:

conn=101857584, query='SELECT * FROM attributo'
[ fetched 13 rows ]
conn=101857584, query='SELECT COUNT (*) FROM attributo'
[ fetched 1 rows ]
conn=101857584, query='SELECT INVALID SELECT STATEMENT TO FORCE ODBC
DRIVER TO UNPREPARED STATE'
ERROR from backend during send_query: 'ERROR: parser: parse error at or
near "select"'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'

------------------------------------------------------------
hdbc=101857584, stmt=102041176, result=0
manual_result=0, prepare=0, internal=0
bindings=101974496, bindings_allocated=1
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT INVALID SELECT
STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE'
stmt_with_params='SELECT INVALID SELECT STATEMENT TO
FORCE ODBC DRIVER TO UNPREPARED STATE'
data_at_exec=-1, current_exec_param=-1, put_data=0
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_CUR06150658'
----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:
parser: parse error at or near "select"'
------------------------------------------------------------
henv=101850696, conn=101857584, status=1, num_stmts=16
sock=101850712, stmts=101850760, lobj_type=-999
---------------- Socket Info -------------------------------
socket=248, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=101863920, buffer_out=101868024
buffer_filled_in=50, buffer_filled_out=0, buffer_read_in=50

Of course "SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO
UNPREPARED STATE"
is not a SQL command, but I don't undestand who is issuing that nor is
meaning.
If I understand correctly, Autocad uses ADO to access databases. Any
hints?
Bye and thanks in advance
Andrea

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message fatih cenesiz 2001-01-05 13:17:15 setBytes() does not work
Previous Message Tom Samplonius 2001-01-05 05:29:49 Re: getting perl to talk to postgres