[HY000] no error information; Error while preparing parameters

From: Daniil Megrabyan <danil(dot)megrabjan(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: [HY000] no error information; Error while preparing parameters
Date: 2017-02-03 08:06:23
Message-ID: AA343437-E0AD-4939-9B7E-C539E8AA392D@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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?

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2017-02-03 10:17:23 Re: Problem calling a function from ODBC application
Previous Message Adrian Klaver 2017-02-02 03:15:39 Re: Problem calling a function from ODBC application