Message-ID: <3A55A0E3.9BE7CC61@comune.modena.it>
Date: Fri, 05 Jan 2001 11:24:35 +0100
From: "Andrea Aime" <aaime@comune.modena.it>
Reply-To: andrea.aime@comune.modena.it
MIME-Version: 1.0
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: ODBC experts needed!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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