Jump to content

SQL Server connection woes


glam_rock

Recommended Posts

Hey guys,

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.  :shrug: 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.  :'(

 

edit:

PHP Version 5.2.8

SQL Server 8.0.2039

 

Link to comment
Share on other sites

mssql was depreciated as a driver by microsoft themselves, which is a pain because it was more in keeping with the function set of others like mysql.  It's likely that mssql does not have fully supported ODBC connection settings within the database drivers any more, it's microsoft's style of things when they upgrade.

 

because of this I would suggest that you replace all youe mssql functions with the sqlsrv eqivelents, to save problems in the future.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.