Re: [HY000] no error information; Error while preparing parameters

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

What does the Postgres server log show?

>
> 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
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com