psqlodbc - prepared statement crash

Поиск
Список
Период
Сортировка
От Xuesong Gao
Тема psqlodbc - prepared statement crash
Дата
Msg-id SN6PR16MB257432B26AE20A788EECE3CDA9C00@SN6PR16MB2574.namprd16.prod.outlook.com
обсуждение исходный текст
Ответы Re: psqlodbc - prepared statement crash  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Список 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

 

 

Song  X. Gao
Solutions Architect

Email xgao@senturus.com
Mobile 732 406 6347
senturus.com

 

 

Вложения

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'
Следующее
От:
Дата:
Сообщение: RE: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'