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
