Does MyODBC support bigint on Linux?
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]
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.