Cant insert into table
"yogesh kumthekar" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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.