Re: [ODBC] [HY000] no error information; Error while preparingparameters

Hi Daniil,

On 2017/02/03 17:06, Daniil Megrabyan wrote:
> Hi,
>
> _Sometimes_ I’m getting very «informative» error message on SQLExecute(). The query is quite easy, but I’m guessing
thaterror comes from the driver(or driver manager though?). What should I check? 

Could you take mylog output and send it to me?

regards,
Hiroshi Inoue

> My environment:
> macOS 10.12
> unixODBC 2.3.4
> psqlodbc 09.05.0400
> PostgreSQL 9.5.4_1
>
> Trace:
> [ODBC][5368][1486063625.565019][SQLAllocHandle.c][1085]
>         Exit:[SQL_SUCCESS]
>             Output Handle = 0x102915800
> [ODBC][5368][1486063625.565280][SQLSetStmtAttr.c][265]
>         Entry:
>             Statement = 0x102915800
>             Attribute = SQL_ATTR_CURSOR_TYPE
>             Value = 0x1
>             StrLen = 0
> [ODBC][5368][1486063625.565463][SQLSetStmtAttr.c][928]
>         Exit:[SQL_SUCCESS]
> [ODBC][5368][1486063625.565851][SQLPrepare.c][196]
>         Entry:
>             Statement = 0x102915800
>             SQL = [INSERT INTO Core_Message(channel_id, date, member_id, reply_id)
> VALUES(25, '2017-02-02 22:27:05', 4, NULL)
> ][length = 109 (SQL_NTS)]
> [ODBC][5368][1486063625.565943][SQLPrepare.c][377]
>         Exit:[SQL_SUCCESS]
> [ODBC][5368][1486063625.566442][SQLExecute.c][187]
>         Entry:
>             Statement = 0x102915800
> [ODBC][5368][1486063625.566724][SQLExecute.c][357]
>         Exit:[SQL_ERROR]
>         DIAG [HY000] no error information;
> Error while preparing parameters
>
> [ODBC][5368][1486063625.567160][SQLFreeHandle.c][381]
>         Entry:
>             Handle Type = 3
>             Input Handle = 0x102915800
> [ODBC][5368][1486063625.567308][SQLFreeHandle.c][494]
>         Exit:[SQL_SUCCESS]
>
>
> Thanks in advance.
>
> Daniil A Megrabyan
> — Daniil A Megrabyan —
> phone(telegram, whatsapp, viber) : +79151762470 | skype: danil.megrabyan