[freetds] Cant insert into table
yogesh kumthekar
yogesh_soft at rediffmail.com
Tue Mar 2 07:44:40 EST 2010
Hi,
I am trying to insert a row in the table "ts"
Column_name Type Length Prec Scale Nulls Default_name Rule_name Access_Rule_name Ident
-------------- ------- --------- ------- -------- -------- --------------- ------------ ------------------- --------
symbol char 25 (null) (null) true (null) (null) (null) false
price float 8 (null) (null) true (null) (null) (null) false
I am using unixODBC 2.2.4 with FreeTDS 0.82. I enabled tracing of driver manager, following is the log for unixODBC DriverManager log:
Entry:
Statement = b7c350
SQL = [ insert into ts values(? , ? ) ][length = 59 (SQL_NTS)]
[ODBC][26229][1267517864.478248][../../unixODBC-2.2.14/DriverManager/SQLPrepare.c][367]
Exit:[SQL_SUCCESS]
[ODBC][26229][1267517864.478276][../../unixODBC-2.2.14/DriverManager/SQLBindParameter.c][213]
Entry:
Statement = b7c350
Param Number = 1
Param Type = 1
C Type = 1 SQL_C_CHAR
SQL Type = 12 SQL_VARCHAR
Col Def = 4096
Scale = 0
Rgb Value = b813c0
Value Max = 4097
StrLen Or Ind = b6f2e0
[ODBC][26229][1267517864.478286][../../unixODBC-2.2.14/DriverManager/SQLBindParameter.c][240]Error: HY090
[ODBC][26229][1267517864.478350][../../unixODBC-2.2.14/DriverManager/SQLGetDiagRec.c][739]
Entry:
Statement = b7c350
Rec Number = 1
SQLState = b7ff10
Native = b802f8
Message Text = b7fb28
Buffer Length = 511
Text Len Ptr = fffffd7ff2ffcdbe
[ODBC][26229][1267517864.478378][../../unixODBC-2.2.14/DriverManager/SQLGetDiagRec.c][776]
Exit:[SQL_SUCCESS]
SQLState = HY090
Native = b802f8 -> 0
Message Text = [[unixODBC][Driver Manager]Invalid string or buffer length]
Can anybody tell me how am I getting "Invalid Buffer Length" message?
I have searched the internet but could not find any information regarding this.
More information about the FreeTDS
mailing list