MySQL Forums
Forum List  »  Connector/ODBC

Does MyODBC support bigint on Linux?
Posted by: Dmitry Kazakov
Date: November 20, 2004 04:48AM

It appears that any prepared statement with ? for a SQL_BIGINT does not work. SQLExecute helpfully reports: "You have an error in your SQL syntax near '' at line 1".

It is also interesting that the same code which works under Windows fails under Linux.

The system is Fedora Core 2
kernel-2.6.9-1.3_FC2
MyODBC-2.50.39-18.1
mysql-3.23.58-9
mysql-server-3.23.58-9

The following is a fragment of the trace file (I carefuly verified that all other parameters are OK):
-------------------------------------------------
[ODBC][4824][SQLPrepare.c][180]
Entry:
Statement = 0x8bb0000
SQL = [INSERT INTO objects VALUES (?, ?, ?, ?, ?, Now())][length = 49]
[ODBC][4824][SQLPrepare.c][355]
Exit:[SQL_SUCCESS]
[ODBC][4824][SQLBindParameter.c][193]
Entry:
Statement = 0x8bb0000
Param Number = 1
Param Type = 1
C Type = -25 SQL_C_SBIGINT
SQL Type = -5 SQL_BIGINT
Col Def = 0
Scale = 0
Rgb Value = 0xbff79318
Value Max = 0
StrLen Or Ind = 0xbff792f8
[ODBC][4824][SQLBindParameter.c][339]
Exit:[SQL_SUCCESS]
[ODBC][4824][SQLBindParameter.c][193]
Entry:
Statement = 0x8bb0000
Param Number = 2
Param Type = 1
C Type = -8 SQL_C_WCHAR
SQL Type = -1 SQL_LONGVARCHAR
Col Def = 8
Scale = 0
Rgb Value = 0xbff78bd8
Value Max = 0
StrLen Or Ind = 0xbff792f0
[ODBC][4824][SQLBindParameter.c][339]
Exit:[SQL_SUCCESS]
[ODBC][4824][SQLBindParameter.c][193]
Entry:
Statement = 0x8bb0000
Param Number = 3
Param Type = 1
C Type = 1 SQL_C_CHAR
SQL Type = -1 SQL_LONGVARCHAR
Col Def = 12
Scale = 0
Rgb Value = 0xbff78bb8
Value Max = 0
StrLen Or Ind = 0xbff792f4
[ODBC][4824][SQLBindParameter.c][339]
Exit:[SQL_SUCCESS]
[ODBC][4824][SQLBindParameter.c][193]
Entry:
Statement = 0x8bb0000
Param Number = 4
Param Type = 1
C Type = 1 SQL_C_CHAR
SQL Type = -1 SQL_LONGVARCHAR
Col Def = 0
Scale = 0
Rgb Value = 0xbff78ba8
Value Max = 0
StrLen Or Ind = 0xbff792ec
[ODBC][4824][SQLBindParameter.c][339]
Exit:[SQL_SUCCESS]
[ODBC][4824][SQLBindParameter.c][193]
Entry:
Statement = 0x8bb0000
Param Number = 5
Param Type = 1
C Type = 1 SQL_C_CHAR
SQL Type = -1 SQL_LONGVARCHAR
Col Def = 1
Scale = 0
Rgb Value = 0xbff78b98
Value Max = 0
StrLen Or Ind = 0xbff792e8
[ODBC][4824][SQLBindParameter.c][339]
Exit:[SQL_SUCCESS]
[ODBC][4824][SQLExecute.c][193]
Entry:
Statement = 0x8bb0000
[ODBC][4824][SQLExecute.c][354]
Exit:[SQL_ERROR]
DIAG [42000] [TCX][MyODBC]You have an error in your SQL syntax near '' at line 1

[ODBC][4824][SQLGetDiagRec.c][710]
Entry:
Statement = 0x8bb0000
Rec Number = 1
SQLState = 0xbff78630
Native = 0xbff78868
Message Text = 0xbff78740
Buffer Length = 256
Text Len Ptr = 0xbff78866
[ODBC][4824][SQLGetDiagRec.c][747]
Exit:[SQL_SUCCESS]
SQLState = 42000
Native = 0xbff78868 -> 1064
Message Text = [[unixODBC][TCX][MyODBC]You have an error in your SQL syntax near '' at line 1]

Options: ReplyQuote


Subject
Written By
Posted
Does MyODBC support bigint on Linux?
November 20, 2004 04:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.