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

Freddy...  just a typo... The DB was called something else, i just renamed
it for privacy...

Consider its defined MYDB both ways.

Regards,
Stallon Selvan


On Thu, Jul 22, 2010 at 2:16 PM, Frediano Ziglio <[email protected]> wrote:

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