Re: psqlodbc - prepared statement crash
От | Inoue, Hiroshi |
---|---|
Тема | Re: psqlodbc - prepared statement crash |
Дата | |
Msg-id | da0774fd-331b-0938-cd80-42104f3dc289@dream.email.ne.jp обсуждение исходный текст |
Ответ на | psqlodbc - prepared statement crash (Xuesong Gao <xgao@senturus.com>) |
Ответы |
RE: psqlodbc - prepared statement crash
(Xuesong Gao <xgao@senturus.com>)
|
Список | pgsql-odbc |
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
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 ArchitectEmail xgao@senturus.com
Mobile 732 406 6347
senturus.com
В списке pgsql-odbc по дате отправления: