From: Tony Simopoulos <karkalis@earthling.net>
To: pgsql-interfaces@postgresql.org
Subject: ODBC parameter binding
Date: Wed, 10 Jan 2001 12:43:03 -0500
Message-ID: <06e201c07b2c$c8bc8770$0382a8c0@metavera.com> (raw)
we are having problems getting the *nix ODBC driver (that came as part of the postgresql bundle) to bind values to the parameters
given in the query.
looking through the log file, and the code, it appears that the driver has no idea what the database type the column should be. are
there any special tables that the db requires in order to do this -- i poked around a little but didn't find any instructions on any
data prep work, that is required to allow full ODBC functionality.
my statement to be parsed is "select * from routes where name = ?"
the driver correctly determines the input type (cType) to be SQL_CHAR, but has no idea what the database type (sqlType) should be.
as such, the code assumes that it is either a NUMERIC or BIT field, and finally resolves the statement as: "select * from routes
where name = foo". this of course is wrong and fails because the single quotes are missing from around 'foo'.
my only guess is that my database needs to prepped. any other ideas??
here is the log file output in question.
<snip>
**** SQLAllocStmt: hdbc = 136564736, stmt = 136794112
CC_add_statement: self=136564736, stmt=136794112
SQLGetInfo: entering...fInfoType=8
SQLGetInfo: p='<NULL>', len=4, value=191, cbMax=4
SQLSetStmtOption: entering...
SetStmtOption(): SQL_CURSOR_TYPE = 2
SQLPrepare: entering...
**** SQLPrepare: STMT_ALLOCATED, copy
SQLNumParams: entering...
SC_pre_execute: status = 1
preprocess: status = READY
SQLExecute: entering...
SQLExecute: clear errors...
SQLExecute: copying statement params: trans_status=1, len=35, stmt='select * fro
m routes where name = ?'
stmt_with_params = 'select * from routes where name = '
Sending SELECT statement on stmt=136794112, cursor_name='SQL_CUR0x8275000
'
send_query(): conn=136564736, query='select * from routes where name = '
send_query: done sending query
send_query: got id = 'Z'
read 44, global_socket_buffersize=4096
send_query: got id = 'E'
send_query: 'E' - ERROR: parser: parse error at or near ""
done sending the query:
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executi
ng the query'
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: parser: parse
error at or near ""'
preprocess: after status = FINISHED, so set PREMATURE
SQLNumResultCols: result = 0, status = 2, numcols = -1
STATEMENT ERROR: func=SQLNumResultCols, desc='', errnum=3, errmsg='No query has
been executed with that handle'
CONN ERROR: func=SQLNumResultCols, desc='', errnum=110, errmsg='ERROR: parser:
parse error at or near ""'
SQLDescribeParam: entering...
STATEMENT ERROR: func=SQLDescribeParam, desc='', errnum=11, errmsg='Invalid para
meter number for SQLDescribeParam.'
CONN ERROR: func=SQLDescribeParam, desc='', errnum=110, errmsg='ERROR: parser:
parse error at or near ""'
SQLBindParameter: entering...
SQLBindParamater: ipar=0, paramType=1, fCType=1, fSqlType=0, cbColDef=-107794601
2, ibScale=-9800, rgbValue=135605836, *pcbValue = 4, data_at_exec = 0
SQLFreeStmt: entering...hstmt=136794112, fOption=0
recycle statement: self= 136794112
SC_free_params: ENTER, self=136794112
SC_free_params: EXIT
SQLExecute: entering...
SQLExecute: clear errors...
SQLExecute: copying statement params: trans_status=1, len=35, stmt='select * fro
m routes where name = ?'
copy_statement_with_params: from(fcType)=1, to(fSqlType)=0
stmt_with_params = 'select * from routes where name = crap'
Sending SELECT statement on stmt=136794112, cursor_name='SQL_CUR0x8275000
'
send_query(): conn=136564736, query='select * from routes where name = crap'
send_query: done sending query
read 1, global_socket_buffersize=4096
send_query: got id = 'Z'
read 37, global_socket_buffersize=4096
send_query: got id = 'E'
send_query: 'E' - ERROR: Attribute 'crap' not found
done sending the query:
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executi
ng the query'
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: Attribute 'cra
p' not found'
**** SQLError: henv=0, hdbc=0, hstmt=136794112
SC_get_error: status = 1, msg = #Error while executing the query;
ERROR: Attribute 'crap' not found#
szSqlState = 'S1000', szError='Error while executing the query;
ERROR: Attribute 'crap' not found'
SQLFreeStmt: entering...hstmt=136794112, fOption=3
SC_free_params: ENTER, self=136794112
SC_free_params: EXIT
<snip>
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: karkalis@earthling.net
Subject: Re: ODBC parameter binding
In-Reply-To: <06e201c07b2c$c8bc8770$0382a8c0@metavera.com>
* 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