Re: DB problem with MSSQL?
| From: | Frank M. Kromann | Date: | Wed, 04 Dec 2002 18:12:39 +0000 |
| Subject: | Re: DB problem with MSSQL? | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-11349@lists.php.net to get a copy of this message | ||
When you are on a Linux box you can only use Sybase functions to access a
MSSQL database.
The confusing part is the aliases for mssql_* when you use the Sybase
extension but you are realy using the sybase_* functions.
- Frank
> Hi there,
>
> is there a known problem with PEAR::DB when connecting from a Linux
> box to an MSSQL server on Windows?
>
> I have made two test scripts: One uses the native MSSQL functions, the
> other one PEAR::DB. I want to retrieve the result rows as associative
> arrays, so I´m using mssql_fetch_array in script 1 and
> $result->fetchRow(DB_FETCHMODE_ASSOC) in script 2.
>
> Script 1 returns exactly what it should: An array that is both indexed
> and associative. Script 2 returns only an indexed array, which is
> useless to me :-(
>
> Does anyone have an idea?
>
> 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
>
>
> --
> PEAR Development Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>