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

And are you sure that your environment variables for your web server are set
properly? That has bitten me in the behind a few times.

On Thu, Jul 22, 2010 at 1:58 AM, Frediano Ziglio <[email protected]> wrote:

> Mmm.... is quite strange that changing only protocol cause entry do
> not be readed. Usually problems with PHP are due to the fact that PHP
> user is different from your one. Are you sure that freetds.conf file
> you change are the right one and that is still readable by PHP after
> your change ?
>
> freddy77
>
> 2010/7/22 Stallon Selvan <[email protected]>:
> > 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
> >>
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
Robert Gonzalez
http://www.robert-gonzalez.com
http://twitter.com/RobertGonzalez
http://www.linkedin.com/in/robertanthonygonzalez