Bug #15338 Updated: Can't select database with '-' in name.
ID: 15338
Updated by: mikef@microtech.com
-Summary: Can't select database with '-' in name.
Reported By: mikef@microtech.com
-Status: Feedback
+Status: Closed
Bug Type: MSSQL related
Operating System: windows NT IIS
PHP Version: 4.1.1
New Comment:
Sorry for what apparently was simply an SQL syntax issue. The [My-DB]
works just fine.
Previous Comments:
------------------------------------------------------------------------
[2002-02-02 03:33:41] mfischer@php.net
It is feedback until the submitter reports something back.
------------------------------------------------------------------------
[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
Thread (6 messages)