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: Frediano Ziglio <freddy77 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: Thu, 22 Jul 2010 10:58:50 +0200

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