Bug #15338 Updated: Can't select database with '-' in name.

ID: 15338 Updated by: mfischer@php.net Old Summary: Can't select database with '-' in name. Reported By: mikef@microtech.com Old Status: Bogus Status: Feedback Bug Type: MSSQL related Operating System: windows NT IIS PHP Version: 4.1.1 New Comment: It is feedback until the submitter reports something back. Previous Comments: ------------------------------------------------------------------------ [2002-02-02 00:16:31] yohgaki@php.net In PHP bug db, cloased is used for fixed bugs/problems. Bogus should be the correct status :) ------------------------------------------------------------------------ [2002-02-01 20:00:41] fmk@php.net 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. ------------------------------------------------------------------------ [2002-02-01 19:46:52] mikef@microtech.com 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