FreeTDS Development Group

[Royce Smallbone <royce.smallbone AT laneend.net>]

On 18 Jul 2008, at 09:49, "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com 
> wrote:

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

Thank you for the information. If you require any testing for this  
please contact me. I don't think I can help in any other way.

Royce