pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC experts needed!
4+ messages / 4 participants
[nested] [flat]
* ODBC experts needed!
@ 2001-01-05 10:24 Andrea Aime <aaime@comune.modena.it>
0 siblings, 2 replies; 4+ messages in thread
From: Andrea Aime @ 2001-01-05 10:24 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ODBC experts needed!
@ 2001-01-05 14:41 Thomas Lockhart <lockhart@fourpalms.org>
parent: Andrea Aime <aaime@comune.modena.it>
1 sibling, 0 replies; 4+ messages in thread
From: Thomas Lockhart @ 2001-01-05 14:41 UTC (permalink / raw)
To: andrea.aime@comune.modena.it; +Cc: pgsql-interfaces
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ODBC experts needed!
@ 2001-01-05 14:57 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Andrea Aime <aaime@comune.modena.it>
1 sibling, 0 replies; 4+ messages in thread
From: Thomas Lockhart @ 2001-01-05 14:57 UTC (permalink / raw)
To: andrea.aime@comune.modena.it; +Cc: pgsql-interfaces
> 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.)
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: ODBC experts needed!
@ 2001-01-05 15:20 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Dave Page @ 2001-01-05 15:20 UTC (permalink / raw)
To: 'lockhart@fourpalms.org' <lockhart@fourpalms.org>; andrea.aime@comune.modena.it; +Cc: pgsql-interfaces
> -----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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-01-05 15:20 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-05 10:24 ODBC experts needed! Andrea Aime <aaime@comune.modena.it>
2001-01-05 14:41 ` Thomas Lockhart <lockhart@fourpalms.org>
2001-01-05 14:57 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
2001-01-05 15:20 RE: ODBC experts needed! Dave Page <dpage@vale-housing.co.uk>
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