Warning: MS SQL: Unable to connect to server

[sebsol]

Hello all,

I have a weird problem on a PHP site.
This site has a administration part. The admin accesses the MS SQL 7.0 with the same string than the site, the same file. The site is working fine but I get this on the admin:
Warning: MS SQL: Unable to connect to server: OUR DATABASE in E:\site\databasecall.php on line 6
Not working

The databasecall is the one used by the front office and the back office:
<?
/*This is the database connection for the galderma website*/

$db_conn = mssql_connect(&quot;OUR DATABASE&quot;,&quot;**&quot;,&quot;**&quot or die (&quot;Not working&quot;
mssql_select_db (&quot;db&quot;,$db_conn) or die (&quot;&quot;
?>

Anybody, any idea, any how, anywhere, anyway?????

Thanks.

Seb

 

[DRJ478]

A note on the side:

Why are you acessing the site with the same credentials as the administrator? Isn't that undesirable?

I assume that the database server has some logs. Look in there for entries for the failed attempt. If there is nothing in there the connection failed before MSSQL got involved.

You should also use mssql_get_last_message to learn more about the failure.

 

[sleipnir214]

Are you sure that both scripts are invoking mysql_connect() the same way?

I'm asking because &quot;OUR DATABASE&quot; is not resolvable to an IP address, as it has a space in it.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

Of course, I may be simply interpreting your code post as literal code, where you have replaced the server name you're actually using with another string for security reasons.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sebsol]

Thanx DR and sleip,

Sleip, indeed OUR DATABASE is for security reason ;-)
DR, I didn't build the code and I would have had 2 users as you mentionned. For the logs, unfortunately, I'm trying to troubleshoot from the distance and I can't have access to them and it will be hard to get them but I'll try.

Thanks again.