Обсуждение: ODBC experts needed!

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

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

Autocad or ADO is issuing this, apparently as a pitiful attempt to reset
the ODBC connection. Have you managed to get this to work with some
other database product? If the intent of the program was to send an
invalid command (which to their credit is well documented in the invalid
command itself), it seems to have succeeded, so what exactly is the
problem?
                       - Thomas

(Sorry for the duplicate messages Andrea, I've got a new address at home
and I'm trying to get my mailing address to line up with my previous
subscription address since majordomo is rejecting my replies.)

> -----Original Message-----
> From: Thomas Lockhart [mailto:lockhart@alumni.caltech.edu]
> Sent: 05 January 2001 14:57
> To: andrea.aime@comune.modena.it
> Cc: pgsql-interfaces
> Subject: Re: [INTERFACES] ODBC experts needed!
> 
> 
> > 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?
> 
> Autocad or ADO is issuing this, apparently as a pitiful 
> attempt to reset
> the ODBC connection. 

I would guess that it's AutoCAD as I've never seen ADO do anything even
remotely like that in all the code I've written using it. Having said that,
if AutoCAD is using ADO, why would it care what state the ODBC driver was
in?

Regards,

Dave.

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

Autocad or ADO is issuing this, apparently as a pitiful attempt to reset
the ODBC connection. Have you managed to get this to work with some
other database product? If the intent of the program was to send an
invalid command (which to their credit is well documented in the invalid
command itself), it seems to have succeeded, so what exactly is the
problem?
                       - Thomas