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: Royce Smallbone <royce.smallbone AT laneend.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MS Sql 2005 and prepared queries
  • Date: Fri, 18 Jul 2008 10:47:50 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page