RE: [PHP] PHP + MSSQL win32 / SOLVED
Hello, I found the problem about my last message (see below). This relates to a bug in 4.3.10 release with MSSQL extension Bug #31372 I downgraded to PHP 4.3.8 and the problem was solved. Thank you for your attention and replies Vincent -Original Message- From: Vincent DUPONT Sent: mercredi 12 janvier 2005 21:54 To: php-general@lists.php.net Subject: [PHP] PHP + MSSQL win32 Hi I try to use PHP with MSSQL on a WINXP station. Usually, on win32 systems this works very well, but today I can't understand the problem. I can connect and execute SELECT statements When I try to INSERT , DELETE or UPDATE a record, I have a PHP ERROR, and a MSSQL error code 15457 in the mssql logs The insert executes, but I would like not to have the php error... This seem to be a problem with grants or permissions, but I can't find where. Even if I log with the 'sa' account I have the error. I use PHP 4.3.10 and MSSQL2000 on winXP pro Any tip would be nice. Moreover, I have found a ini file parameter that is not documented : mssql.datetimeconvert=Off Do you know what does this mean?? Thank you Vincent -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP + MSSQL Problem
Alaor Barroso wrote: I changed the php.ini and enabled the support for MSSQL and now i can connect without errors, BUT when make an query to an table the query return NO MATCHES, i have sure that the SQL line is correct (i already used it on(or in? i don't know the difference =P) other site - in other server - and it works AND i have sure that the SQL should return data because the WHERE point to an fiels value that exists... It looks like PHP can't communicate with MSSQL but it connect! Strange... Show us some source code. Any error messages show up? If not, try to use http://php.net/mssql_error to get some error messages to show up. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] [PHP - MSSQL]: Problem with mssql_connect
Change MS SQL SERVER Authentication's type to SQL Server and Windows instead of windows only. Ongart Wongsanupa [EMAIL PROTECTED] 09/18/2003 04:25 PM To: [EMAIL PROTECTED] cc: Subject:[PHP] [PHP - MSSQL]: Problem with mssql_connect Please help!... I have to use 'apache+php' connect to MSSQL Server 2000 in Windows Server 2003, but there are problem. Computer A: Windows Server 2003 Enterprise, MSSQL Server 2000 Enterprise, Computer B: Windows XP Professional, Apache, php ( Web Server ) Computer A -- network - Computer B I try to write php script such this.. mssql_connect('server','sa',''); but the result is: ***message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in ...*** Please help me find out the problem.. m(_ _)m and sorry for my english language, + + + + + + + + + + + + + + + + + + + [the thing that I did]... 1. I install client part from MSSQL Server CD Installer into Computer B already and I'm sure for ntwdblib.dll or php_mssql.dll is newest version that I can find.. 2. I set Authentication in MSSQL Server to be 'SQL Server and Windows' already + + + + [ but the problem still happen ] + + -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] [PHP - MSSQL]: Problem with mssql_connect
I did it already,. but that's not help thank for advice.. Larry Li [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] . Change MS SQL SERVER Authentication's type to SQL Server and Windows instead of windows only. Ongart Wongsanupa [EMAIL PROTECTED] 09/18/2003 04:25 PM To: [EMAIL PROTECTED] cc: Subject:[PHP] [PHP - MSSQL]: Problem with mssql_connect Please help!... I have to use 'apache+php' connect to MSSQL Server 2000 in Windows Server 2003, but there are problem. Computer A: Windows Server 2003 Enterprise, MSSQL Server 2000 Enterprise, Computer B: Windows XP Professional, Apache, php ( Web Server ) Computer A -- network - Computer B I try to write php script such this.. mssql_connect('server','sa',''); but the result is: ***message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in ...*** Please help me find out the problem.. m(_ _)m and sorry for my english language, + + + + + + + + + + + + + + + + + + + [the thing that I did]... 1. I install client part from MSSQL Server CD Installer into Computer B already and I'm sure for ntwdblib.dll or php_mssql.dll is newest version that I can find.. 2. I set Authentication in MSSQL Server to be 'SQL Server and Windows' already + + + + [ but the problem still happen ] + + -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP MSSQL Images
* Thus wrote [EMAIL PROTECTED] ([EMAIL PROTECTED]): ... The following is the tag inserted to my webpage: img src=showpic.php?picid=1 View the source of this image to see if any php errors are being displayed. Curt -- I used to think I was indecisive, but now I'm not so sure. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP - mssql
-Original Message- From: chris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 3:38 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP - mssql ?PHP $link = mssql_connect($hostname,$username,$password); $dblink = mssql_select_db($dbname, $link); if ( $link $dblink ) { $query = select * from members where user = '$user' and pass = '$pass'; $result = mssql_query( $query ); if ( $result ) echo correct login; else echo wrong login; } ? This is not working... i have tried everything i can think of that can work but with no luck. In what way isn't it working? Do you get an error message, or just not the result you were expecting? If it's the latter (in particular, if you're getting correct login no matter what values you use for $user and $pass), the issue is likely related to the fact that mssql_query() returns a result identifier which doesn't necessarily have any correlation to the contents of the result set -- it'll only return false if there's an error in your query (and a query can be error-free and still not return data). For what you're doing, you'll probably want to take a look at mssql_num_rows(). --- 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 General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php