Re: DB_FETCHMODE_ASSOC not working with mssql

Am Thu, 22 May 2003 15:23:50 +0200 schrieb "bruno.vernay" <bruno.vernay@proval.fr>: > > Okay, my advice to you is: Do NOT use the Sybase extension! If you´re > > using FreeTDS, use the MSSQL extension. To do that, you need at least > > PHP 4.3.0, as this was the first version that was able to compile > > --with-mssql on Linux. The Sybase extension does NOT provide the full > > API of the MSSQL extension, nor is it entirely compatible to it. That > > will most likely be the problem, as the PEAR::DB driver for MSSQL > > assumes that the "official" MSSQL extension is used. [...] > - I looked at ODBTP, but it requiers to install some stuff on the > MS-SQL-Server, which in my case won't be possible. Too bad :-\ > - I didn't find php-mssql ?? (plus I use php 4.2.3, on Mandrake 9.0) > - I understand that I have to stay with DB 1.3 until I get PHP 4.3 ? Well, I don´t know exactly what was changed in-between DB 1.3 and DB 1.4, so I can´t say whether it is a bug in the new release or an incompatibility issue with the Sybase extension. However, if you want to use the MSSQL extension (which I still _highly_ recommend in your case), all you need to do is upgrade to PHP 4.3.0 and use the compile option "--with-mssql" instead of "--with-sybase". Chances are, your problems with DB 1.4 will disappear then, but that´s only a guess. In any case, not using the Sybase extension for connecting to MSSQL will safe you trouble, so no matter what you try, you can only win :-) Regards, Markus -- *21st Media* | Consulting, Konzeption, Produktion für die Bereiche: Markus Wolff | Internet, Intranet, eCommerce, Content Management, Hamburg,Germany | Softwareentwicklung, 3D-Animation, Videostreaming http://21st.de | Tel. [+49](0)40/6887949-0, Fax: [+49](0)40/6887949-1