Skip to Content.
Sympa Menu

freetds - Re: [freetds] MS Sql 2005 and prepared queries

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MS Sql 2005 and prepared queries
  • Date: Fri, 18 Jul 2008 10:49:52 +0200


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




Archive powered by MHonArc 2.6.24.

Top of Page