Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Stallon Selvan <stallonselvan AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well)
  • Date: Tue, 20 Jul 2010 16:06:12 +0530

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 <freddy77 AT gmail.com> wrote:

>
> Il giorno 13/lug/2010, alle ore 18.53, Stallon Selvan <
> stallonselvan AT gmail.com> 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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page