Cannot connect to mssql

bronto

I have a Windows server with SQL server on it that I have been connecting to with php from external servers and my own laptop for quite some time. Now, we actually have a php script on that server that we want to connect to the localhost mssql with. It's not working. When I view phpinfo, the mssql extensions are enabled. However when I try to connect to using I get:

Connection error to server 'xxx.xxx.xxx.xxx' with user 'username'

which is generated by the adodb library. The exact same credentials work on my dev laptop and on another remote server. I have tried with with just the bare php mssql extensions and the connection fails as well, although I don't get good error messages.

Suggestions?

Shrike

What ADODB connection type are you using? To connect from my windows laptop to a sql server database, I use an ODBC connection with the following connection string

Driver={SQL Server};Server=the-server-name;Database=the-database-name

From our Debian boxes we use a FreeTDS driver.

bronto

Here's what works on my Windows laptop, but doesn't work on the server:

$DB = &ADONewConnection('mssql');  # create a connection
$DB->SetFetchMode(ADODB_FETCH_BOTH);
$ok = $DB->Connect('xxx.xxx.xxx.xxx','uname','password','dbname');# connect to MySQL

Is is at the Connect that I get a failure. I've also tried PConnect. I've also tried localhost instead of the IP address.