[PHP-DEV] Bug #15338 Updated: Can't select database with '-' in name.
ID: 15338 Updated by: [EMAIL PROTECTED] -Summary: Can't select database with '-' in name. Reported By: [EMAIL PROTECTED] -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] [EMAIL PROTECTED] It is feedback until the submitter reports something back. [2002-02-02 00:16:31] [EMAIL PROTECTED] In PHP bug db, cloased is used for fixed bugs/problems. Bogus should be the correct status :) [2002-02-01 20:00:41] [EMAIL PROTECTED] 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] [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=15338edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DEV] Bug #15338 Updated: Can't select database with '-' in name.
ID: 15338 Updated by: [EMAIL PROTECTED] Old Summary: Can't select database with '-' in name. Reported By: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] In PHP bug db, cloased is used for fixed bugs/problems. Bogus should be the correct status :) [2002-02-01 20:00:41] [EMAIL PROTECTED] 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] [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=15338edit=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]
[PHP-DEV] Bug #15338 Updated: Can't select database with '-' in name.
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=15338edit=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]
[PHP-DEV] Bug #15338 Updated: Can't select database with '-' in name.
ID: 15338 Updated by: [EMAIL PROTECTED] Old Summary: Can't select database with '-' in name. Reported By: [EMAIL PROTECTED] Old Status: Closed Status: Bogus Bug Type: MSSQL related Operating System: windows NT IIS PHP Version: 4.1.1 New Comment: In PHP bug db, cloased is used for fixed bugs/problems. Bogus should be the correct status :) Previous Comments: [2002-02-01 20:00:41] [EMAIL PROTECTED] 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] [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=15338edit=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]