[PHP-DB] MSSQL Error message
Hi I´m using a connection using php 4.3.3 with sql server ... and i´m having a error message : mssql error: [: Connection error to server '192.0.0.6\binotto' with user 'LUA'] .. The user 'LUA' is the dbowner ... anyone can help me??? Sorry my bad english ... Liana Cristine Leopold
[PHP-DB] MSSQL error
I am getting problems with MSSql when using DB.php, I have an intermitant fualt where php keeps gives me a CGI The specified CGI application misbehaved by not returning a complete set of HTTP headers (you know the one), but when the page is refreshed it all works fine. I have a felling that it my be something to do with caching but don't know where to look, this same program works fine with mysql, but keeps on getting this error in MSSql. if anyone has had this problem before, or has any ideas please let me know. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MSSQL Error with MSSQL 2000
When we run an insert query in MS SQL Server we get the following error Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. On the following website we found this had to do something with the NTEXT-type. http://www.bmc.com/products/distdata/sqlprogfaq.html#error_odbc Now how should we store a memo-field on MSSQL using php_mssql dll? -- http://hace.dyndns.org/ Everything I say is my own opinion and not necessarily that of my employer. -- PHP Database 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]
RE: [PHP-DB] MSSQL Error with MSSQL 2000
Hi, DB-Library based drivers don't fully support SQLServer 2000. If you are on Windows, use ODBC with the native driver or download the OpenLink Single or Multi-Tier driver. If you are on Linux, you can use the OpenLink Multi-Tier driver for SQLServer. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Hace [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 7:04 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL Error with MSSQL 2000 When we run an insert query in MS SQL Server we get the following error Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. On the following website we found this had to do something with the NTEXT-type. http://www.bmc.com/products/distdata/sqlprogfaq.html#error_odbc Now how should we store a memo-field on MSSQL using php_mssql dll? -- http://hace.dyndns.org/ Everything I say is my own opinion and not necessarily that of my employer. -- PHP Database 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 Database 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-DB] MSSQL error codes :/
I'm getting funky error codes, even with doing addslashes($variable); but its not escaping the 's, I have even resorted to str_replace() and still nothing below is error output. Warning: MS SQL message: Line 1: Incorrect syntax near 'b'. (severity 15) in \jtron\home\admin\functions.php on line 82 Warning: MS SQL message: Unclosed quotation mark before the character string ')'. (severity 15) in \jtron\home\admin\functions.php on line 82 Warning: MS SQL: Query failed in \jtron\home\admin\functions.php on line 82 -- PHP Database 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]
RE: [PHP-DB] MSSQL error codes :/
-Original Message- From: Charles Butler [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 12:56 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL error codes :/ I'm getting funky error codes, even with doing addslashes($variable); but its not escaping the 's, I have even resorted to str_replace() and still nothing below is error output. Warning: MS SQL message: Line 1: Incorrect syntax near 'b'. (severity 15) in \jtron\home\admin\functions.php on line 82 Warning: MS SQL message: Unclosed quotation mark before the character string ')'. (severity 15) in \jtron\home\admin\functions.php on line 82 Warning: MS SQL: Query failed in \jtron\home\admin\functions.php on line 82 I posted in another thread earlier today that the Sybase database engine likes to have a single quote escaped by another single quote, not by a slash. Perhaps this is a case where MSSQL is showing its Sybase roots...do you get the same errors if you change \' to ''? --- Mark Roedel | Blessed is he who has learned to laugh Systems Programmer | at himself, for he shall never cease LeTourneau University | to be entertained. Longview, Texas, USA| -- John Powell -- PHP Database 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]