Skip to Content.
Sympa Menu

freetds - [freetds] Cant insert into table

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "yogesh kumthekar" <yogesh_soft AT rediffmail.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Cant insert into table
  • Date: 2 Mar 2010 12:44:40 -0000

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.




  • [freetds] Cant insert into table, yogesh kumthekar, 03/02/2010

Archive powered by MHonArc 2.6.24.

Top of Page