[freetds] MS Sql 2005 and prepared queries

Royce Smallbone royce.smallbone at laneend.net
Fri Jul 18 05:47:50 EDT 2008


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



More information about the FreeTDS mailing list