FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> > >
> > > 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

Attachment: smime.p7s
Description: S/MIME cryptographic signature