Re: psqlodbc - prepared statement crash

Hi,

Sorry for the late reply.

You seem to turn on Mylog optipn of Global settings only.
Could you please turn on Mylog option of Advanced Options (DataSource)
as well?

I have a question.
What does "city = ..."  of
StatementText = "select city, ? as i from public.city where city = ...",
mean?

regards,
Hiroshi Inoue

On 2019/07/26 22:56, Xuesong Gao wrote:
>
> 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
>
>
>
> *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/>
>

---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com