I am able to connect to our SQLEXPRESS instance:
$connection = @mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");
However, the database I created I cannot select:
$db = @mssql_select_db($myDB, $connection) or die("Couldn't open database $myDB") -> the mssql_select_db returns false.
But I can select from the Default System Databases that were installed as part of the default installation.
So this is perhap more of an MSSQL question, but how can i find the database namespace of my newly created database? I've associated permissions with a user i created to connect, and select from the db.
I've attached a image of the setup of the new database (called menus) in relation to the system databasees.
Any suggestions much appreciated, have kind of hit a wall of inexplicability.
WAIT!
I just reloaded the page, after picking up the boy from daycare, having supper, and in the magic that is degugging a Microsoft product (TM) , i am now getting this error message:
Warning: mssql_query() [function.mssql-query]: message: SELECT permission denied on object 'schools', database 'menus', schema 'dbo'. (severity 14) in C:\Inetpub\wwwroot\mazzola\menus\test.php on line 14
So indeed we now have permissions issue, no problem. Thanks to any who at least thought about the problem.
