PHP + MSSQL 2000 + Multiple Instances

[Anon]

Hello,

I am trying to access a third party Microsoft SQL Database using PHP on a Unix machine. They run their MS SQL database as an instance and I am unable to connect using the regular mssql_connect("IP\Instance", "user", "password") PHP function.

"Note that in MS SQL 2000, there is a new functionality called multiple instances. They are accessed using the following format: <servername><instancename> However, this does NOT work under php. You may only access the primary instance."

My setup is working fine with MS SQL Servers running without multiple instances, but I have not been able to make it work with multiple instances.

Has anybody out there been able to connect to a MS SQL server instance with PHP?

Thanks,

Jose Aguilar

Please reply to [e-mail]

[Anon]

Have you looked into using the sybase protocal?

http://www.phpbuilder.com/columns/alberto20000919.php3

This is what I use to connect to an SQL2000 database from a linux box running PHP.

-Paul