Posts posted by glam_rock
Just a question as I am trying to get php_sqlsrv.dll set up.
The installation now however supplies me with like 6 differently and complexly named dlls.
which one do i use?
error: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server
So I have been banging my head and scouring the internet for help with this and am coming up short.
I write internal php data management applications that run off a small local web server and interact with several different SQL databases.
In this instance I am running two php applications off of one machine. One of them connects fine to it's database using mssql_connect and PDO. A separate application running on the same web server attempts to connect to a different SQL database using the same means and fails. The second database is pingable and in house and i can remote to the machine and access the database via Microsoft SQL Server Management Studio. mssql_connect and PDO both fail and I can't figure out why. A different application can connect to a different SQL database just fine. This tells me that is must be something on the SQL server but the administrator ensures me they are identical configurations.
Any thoughts? Help please. I'm desperate. :'(
PHP Version 5.2.8
SQL Server 8.0.2039
SQL Server connection woes
in Microsoft SQL - MSSQL
I got this working via sqlsrv, but am still curious as to why sqlsrv works and mysql_connect doesn't...