[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