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

From: Date: Sat, 02 Feb 2002 01:00:42 +0000
Subject: Bug #15338 Updated: Can't select database with '-' in name.
References: 1  Groups: php.dev 
Request: Send a blank email to php-dev+get-78834@lists.php.net to get a copy of this message 
ID: 15338
Updated by: fmk@php.net
Old Summary: Can't select database with '-' in name.
Reported By: mikef@microtech.com
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] 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)

« previous php.dev (#78834) next »