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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.