ID: 8679
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Assigned To: 
Comments:

If you use MS Enterprice Manager it is possible to create a atabase called 123Test. It 
is not possible to use Query Analyzer to select the database with the command

use 123Test.

If you select the database as the default database for the userid/password you are 
using it will be possible to access data in it without the use command 
(mssql_select_db/sybase_select_db)

You can not create a table called 123Table using Query Analyzer and in general you 
should always start your names with a letter.

Previous Comments:
---------------------------------------------------------------------------

[2001-01-12 12:35:39] [EMAIL PROTECTED]
ok, it is definitly a bug in the mssql libraries, i've written a short sample c 
program that produces the same output. i'll try to workaround this somehow ...

since it's not a php bug you can close this.



SQL Server message 170, severity 15:
        Line 1: Incorrect syntax near '123'.
DB-LIBRARY error:
        Allgemeiner SQL Server-Fehler: Überprüfen Sie Meldungen vom Computer mit SQL 
Server.
SQL Server message 170, severity 15:
        Line 1: Incorrect syntax near '123'.
DB-LIBRARY error:
        Allgemeiner SQL Server-Fehler: Überprüfen Sie Meldungen vom Computer mit SQL 
Server.
SQL Server message 170, severity 15:
        Line 1: Incorrect syntax near '123'.
DB-LIBRARY error:
        Allgemeiner SQL Server-Fehler: Überprüfen Sie Meldungen vom Computer mit SQL 
Server.
dbsqlexec() failed

---------------------------------------------------------------------------

[2001-01-12 12:11:14] [EMAIL PROTECTED]
here is the errormessage

on win:

Warning: MS SQL message: Line 1: Incorrect syntax near '123'. (severity 15) in 
CDatabaseMSSQL.inc on line 53

Warning: MS SQL: Unable to select database: 123test in CDatabaseMSSQL.inc on line 53


on linux:

mssql_select_db("100BASE",$spojeni) nebo [sybase_select_db... ]  :
Warning: Sybase error: Line 1: Incorrect syntax near '100'. (severity 15) in

---------------------------------------------------------------------------


Full Bug description available at: http://bugs.php.net/?id=8679


-- 
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]

Reply via email to