Problem connecting to server via MsSQLConnect

[Gefry]

Hello,

So here is my problem:

I tried to connect to a database SQL Server 7.0 via windows authentication and it works.
But when I see all the tables, it prompt me with "dtproperties".
I noticed that by using SQL Server Management Studio Express, if I does not run the program administrator (I'm in vista), I could not see the other tables from "dtproperties.
Have you an idea through php if there is a way to see all the tables in the database?

  $ server = "127.0.0.1 \ S QLEXPRESS", / / port 49178 
	  $ username = "foo"; 
	  $ password = "t0t0"; 
	  $ SqlConnection = mssql_connect ($ server, $ username, $ password); 
	  if (false === $ SQLConnect) 
	  ( 
	       echo "Could not connect. \ n"; 
	  ) 
	  else 
	  ( 
		  echo "Connection to server successful <br>"; 
		  mssql_close ($ SQLConnect); 
	  )

However when I run my code, I get the following error:

 Warning: mssql_connect () [function. Mssql-connect]: Unable to connect to server: 127.0 .0 .1 \ sqlexpress

Do you have any leads?

[Adley]

you may use the following code to solve your problem this may happen that you have to do some changes according to your requirements.

im using a MSSQL connection instead...

<?php

// Connection
$svr = 'localhost';
$user = 'username';
$pass = 'password';

// Establish Connection
mssql_connect($svr,$user,$pass)
    or die ('Cannot Connect to MSSQL Server');
mssql_select_db('database');

?>

[Alejandro]

with PHP MS SQL library function if you need to connect the database connection with the then you just need to add just two lines to the PHP.ini file:

[PHP_MSSQL]
extension=php_mssql.dll

If you had of called

$db = mssql_connect(”dbhost”,”username”,”PaSsWoRd”);

If all other things are properly connected then there won't be any problem connecting to the server.