ID: 8679 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Closed Bug Type: MSSQL related Operating System: win2k , linux PHP Version: 4.0.4 New Comment:
I installed freetds version 0.53, PHP 4.12 and Apache 1.2.24 on Redhat Linux 7.2. In my freetds.conf file I set the tds version to 8.0 as I was trying to conenct to that version of MSSQL. I got the following warning: Warning: Sybase error: Line 1: Incorrect syntax near (severity 15) (Bug #8679) If I simply change my tds version to 7.0 it works. I am not certain that it will work for all queries or procedures I need to perform. But I just need to get some very basic stuff out and it is enough for me. Does anyone know if Msoft will start supporting tds version 8.0 Previous Comments: ------------------------------------------------------------------------ [2001-01-12 12:41:14] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=8679&edit=1