Re: SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well)

This problem has nothing to do with protocol. You specified a
"MSSQLDB" server while in freetds.conf you have a "MYDB" server.

freddy77


2010/7/20 Stallon Selvan <[email protected]>:
> Thanks a lot for replying guys... here is the tdsdump
>
> log.c:190:Starting log file for FreeTDS 0.82
>        on 2010-07-12 18:02:50 with debug flags 0x4fff.
> iconv.c:197:names for ISO-8859-1: ISO-8859-1
> iconv.c:197:names for UTF-8: UTF-8
> iconv.c:197:names for UCS-2LE: UCS-2LE
> iconv.c:197:names for UCS-2BE: UCS-2BE
> iconv.c:363:iconv to convert client-side data to the "UTF-8" character set
> iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
> login.c:405:IP address pointer is empty
> login.c:407:Server MSSQLDB not found!
> mem.c:563:tds_free_all_results()
>
> Regards,
> Stallon Selvan
>
>
> On Tue, Jul 20, 2010 at 3:00 AM, Frediano Ziglio <[email protected]> wrote:
>
>>
>> Il giorno 13/lug/2010, alle ore 18.53, Stallon Selvan <
>> [email protected]> ha scritto:
>>
>>  freetds.conf:
>>> [MYDB]
>>>       host = 192.168.1.11
>>>       port = 1433
>>>       tds version = 7.0
>>>       client charset = UTF-8
>>>
>>> This works perfectly however if I switch to  tds version = 8.0 (which I
>>> want
>>> to), throws exceptions like:
>>>
>>> The incoming tabular data stream (TDS) remote procedure call (RPC)
>>> protocol
>>> stream is incorrect. Parameter 2 ("@bPublic"): Data type 0x32 is unknown.
>>>
>>> Additionally sometimes, giving me the following errors in some stored
>>> procedures
>>>
>>> stored procedure execution failed in
>>> /home/wwwuser/public_html/db.mssql.php
>>> on line 558.
>>> user warning: Error: - Changed database context to 'Staging_DB'.e
>>>
>>> Regards,
>>> Stallon Selvan
>>>
>>>  Please post a tdsdump.
>>
>> Freddy77
>>
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds