From: | Xuesong Gao <xgao(at)senturus(dot)com> |
---|---|
To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | psqlodbc - prepared statement crash |
Date: | 2019-07-26 13:56:06 |
Message-ID: | SN6PR16MB257432B26AE20A788EECE3CDA9C00@SN6PR16MB2574.namprd16.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I am using MS ODBCTest tool for testing purpose here, and it crashed after I did following steps:
1. Full connect to DSN.
2. SQLPrepare: select city, ? as i from public.city where city = ?
3. SQLBindParameter: number 1, value type SQL_C_CHAR, parameter type SQL_CHAR, value 1;
4. SQLBindParameter: number 2, value type SQL_C_CHAR, parameter type SQL_CHAR, value Abha;
5. SQLExecute
* your ODBC driver version
Unicode x64, 9.06.05.00
* your PostgreSQL database version
PostgreSQL 10, sample database dvdrental
* any error messages you saw on the screen
messages in ODBCTest tool console:
Full Connect(Default)
Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3
Successfully connected to DSN 'dvdrental'.
SQLPrepare:
In: StatementHandle = 0x00000000047221C0, StatementText = "select city, ? as i from public.city where city = ...", TextLength = 51
Return: SQL_SUCCESS=0
SQLBindParameter:
In: StatementHandle = 0x00000000047221C0, ParameterNumber = 1, InputOutputtype = SQL_PARAM_INPUT=1, ValueType = SQL_C_CHAR=1,
ParameterType = SQL_CHAR=1, ColumnSize = 0, DecimalDigits = 0, ParameterValuePtr = "1", BufferLength = 0, StrLen_or_IndPtr = SQL_NTS=-3, SQL_LEN_DATA_AT_EXEC = FALSE,
Buffer Size = 600
Return: SQL_SUCCESS=0
SQLBindParameter:
In: StatementHandle = 0x00000000047221C0, ParameterNumber = 2, InputOutputtype = SQL_PARAM_INPUT=1, ValueType = SQL_C_CHAR=1,
ParameterType = SQL_CHAR=1, ColumnSize = 0, DecimalDigits = 0, ParameterValuePtr = "Abha", BufferLength = 0, StrLen_or_IndPtr = SQL_NTS=-3, SQL_LEN_DATA_AT_EXEC = FALSE,
Buffer Size = 600
Return: SQL_SUCCESS=0
* the debug log (mylog_????.log) file (you will have to enable the mylog driver option)
attached
[X]
Song X. Gao
Solutions Architect
Email xgao(at)senturus(dot)com<mailto:xgao(at)senturus(dot)com>
Mobile 732 406 6347
senturus.com<http://www.senturus.com/>
Attachment | Content-Type | Size |
---|---|---|
mylog_odbct32w_7728.log | application/octet-stream | 2.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | michael.riksman | 2019-07-28 07:45:10 | RE: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported' |
Previous Message | Inoue, Hiroshi | 2019-07-26 11:28:52 | Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported' |