Forum Moderators: coopster

Message Too Old, No Replies

php and mssql (server has 2 instances)

         

mgworek

7:48 pm on Oct 2, 2007 (gmt 0)

10+ Year Member



I am trying to write a web page that connects to my mssql server. The web server is linux based, i believe it is running php 4.

I am having problems connecting, not getting error messages so not sure what is happening. I have the ports opened on my firewall for the sql server.

But when setting up the connection in php, i see no way of picking which instance of sql to connect to on my server. example, server\sql1 or server\sql2. ultimately i am trying to get to the support database that is part of server\sql2.

hope this makes sense and i could be way off but i would think you have to tell php which instance, not just the server ip and database name.

Thanx.

jatar_k

2:13 pm on Oct 3, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



this is what is available from the php side of things
[php.net...]

does it connect at all? or is it just connecting to the wrong instance?