[freetds] MS Sql 2005 and prepared queries

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Jul 18 04:49:52 EDT 2008


> 
> > >
> > > I get am getting the following errors in my odbc log:
> > >
> > > [[FreeTDS][SQL Server]Invalid data type]
> > >
> > > Any guidance would be greatly appreciated.
> > >
> > > Royce
> >
> > You could enable ODBC trace and post last lines.
> > Prepared query should work. Are you sure you are using 
> proper protocol
> > version??
> >
> > freddy77
> 
> I am using TDS version 8.0, I have tried 7.0 and 4.2.
> 
> Str In = 
> [DRIVER=FreeTDS;SERVER=192.168.16.5;Port=1433;DATABASE=synergy
> _hwy_testing;TDS_Version=8.0;UID=synergy_hwy;PWD=*********]
> [length = 119]  
> 
> 
> I assume these are the log entries you are interested in, 
> apologies if I have 
> posted too much I started from the sql statement down:
> 
> [ODBC][16086][SQLPrepare.c][192]
> 		Entry:            
> 			Statement = 0x8213fe8            
> 			SQL = [SELECT access_view, 
> access_print, access_change, access_create, 
> access_delete FROM system.view_security_highlevel WHERE ( 
> securi...][length = 
> 305]
> [ODBC][16086][SQLPrepare.c][367]
> 		Exit:[SQL_SUCCESS]
> [ODBC][16086][SQLBindParameter.c][210]
> 		Entry:            
> 			Statement = 0x8213fe8            
> 			Param Number = 1            
> 			Param Type = 1            
> 			C Type = -8 SQL_C_WCHAR            
> 			SQL Type = -9 SQL_WVARCHAR            
> 			Col Def = 22            
> 			Scale = 0            
> 			Rgb Value = 0x810152a            
> 			Value Max = 22            
> 			StrLen Or Ind = 0xbfe95df4
> [ODBC][16086][SQLBindParameter.c][390]
> 		Exit:[SQL_ERROR]
> 		DIAG [S1004] [FreeTDS][SQL Server]Invalid data type
> 

Wide characters are not supported. There is some code in developing but it's far from
complete.

freddy77
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3129 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080718/e39bc6e5/attachment.bin 


More information about the FreeTDS mailing list