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
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 |