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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.