[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