From: Andrea Aime <aaime@comune.modena.it>
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: ODBC experts needed!
Date: Fri, 05 Jan 2001 11:24:35 +0100
Message-ID: <3A55A0E3.9BE7CC61@comune.modena.it> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: aaime@comune.modena.it
Subject: Re: ODBC experts needed!
In-Reply-To: <3A55A0E3.9BE7CC61@comune.modena.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox