[PHP-DB] mssql_select_db(): Unable to select database:

[blackwater dev]

Hello all,

I set up freetds on one of my servers and everything worked fine.  I just
set it up on another server (this one with the latest php) and now the same
code seems to connect but can't select the db mssql_select_db(): Unable to
select database:.  How can I figure out what's wrong?  The mssql db is
hosted remotely so both servers should be able to hit it fine and are using
the exact same source code.  The differences are they are running different
versions of php and possibly freetds.

Thanks!

Re: [PHP-DB] mssql_select_db(): Unable to select database:

[chris smith]

On 4/9/06, blackwater dev [EMAIL PROTECTED] wrote:
 Hello all,

 I set up freetds on one of my servers and everything worked fine.  I just
 set it up on another server (this one with the latest php) and now the same
 code seems to connect but can't select the db mssql_select_db(): Unable to
 select database:.  How can I figure out what's wrong?  The mssql db is
 hosted remotely so both servers should be able to hit it fine and are using
 the exact same source code.  The differences are they are running different
 versions of php and possibly freetds.

What error do you get?

Hmm looks like there's no mssql_error()...

turn up error reporting:
error_reporting(E_ALL);

and put display errors on:
ini_set('display_errors', true);

see if that gives you any ideas.
--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mssql_select_db

[blackwater dev]

I have some code which connects to a remote SQL server.  The code has
worked fine for a year and now the mssql_select_db is failing.  The
code hasn't changed and I talked to the SQL Server admin who assures
me nothing has changed and I am talking to the web host who says
nothing changed...how can I debug this?

The web host is running FreeBSD with the FreeTDS library and php 4.3.9.

Is there a way to echo all of the mssql tables after I make the
connection?  I can connect fine, just can't select a db so I want to
see what databases php can see.

Thanks!

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php