ID: 15338
Updated by: [EMAIL PROTECTED]
Old Summary: Can't select database with '-' in name.
Reported By: [EMAIL PROTECTED]
Old Status: Open
Status: Closed
Bug Type: MSSQL related
Operating System: windows NT IIS
PHP Version: 4.1.1
New Comment:
If your database name contains '-' or ' ' you can select the database
like this:
mssql_select_db("[my database]");
or
mssql_select_db("[my-database]");
That works fine.
Previous Comments:
------------------------------------------------------------------------
[2002-02-01 19:46:52] [EMAIL PROTECTED]
I have a database on my MSSQL server with a '-' in the database name.
The database works fine with all of my other applications including
ASP. However, I cannot select the database with PHP. Interestingly, a
'-' in the server name doesn't seem to be a problem.
$server="SQL-Server";
$dbName="My-DB";
$user="phpusr";
$passwd="phppass";
$hcon = mssql_connect($server, $user, $passwd);
if ($hcon == FALSE)
die("Could not connect to SQL server '$server'");
$hdb = mssql_select_db($dbName, $hcon);
The resulting message is:
Warning: MS SQL message: Line 1: Incorrect syntax near '-'. (severity
15) in C:\InetPub\PHP\dbtest.php on line 10
Warning: MS SQL: Unable to select database: My-DB in
C:\InetPub\PHP\dbtest.php on line 10
Could not select database 'My-DB'
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=15338&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
