Bug #15400 Updated: Queries Crashing PHP.EXE

ID: 15400 Updated by: john_woodhouse@hammond-logistics.co.uk Reported By: john_woodhouse@hammond-logistics.co.uk -Status: Feedback +Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.1.1 New Comment: Well it does... Tried your way MSSQL_CONNECT("HOST:123", "USER", "PWD"); got Warning: MS SQL: Unable to connect to server: HOST:123 in c:\inetpub\wwwroot\hello.php on line 5 Warning: MS SQL message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in c:\inetpub\wwwroot\hello.php on line 6 Warning: MS SQL: Unable to connect to server: (null) in c:\inetpub\wwwroot\hello.php on line 6 Warning: MS SQL: A link to the server could not be established in c:\inetpub\wwwroot\hello.php on line 6 Warning: MS SQL message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in c:\inetpub\wwwroot\hello.php on line 7 Warning: MS SQL: Unable to connect to server: (null) in c:\inetpub\wwwroot\hello.php on line 7 Warning: MS SQL: A link to the server could not be established in c:\inetpub\wwwroot\hello.php on line 7 Tried MSSQL_CONNECT("HOST,123", "USER", "PWD"); and it crashes... with error stated in first posting Previous Comments: ------------------------------------------------------------------------ [2002-02-06 07:35:20] sander@php.net Are you calling mssql_connect() this way or did I misunderstand it? mssql_connect("[localhost,123]", "[www]", "[secret]"); AFAIK, you should just call mssql_connect("localhost:123", "www", "secret"); Is that your problem? Anyway, it SHOULDN'T crash. ------------------------------------------------------------------------ [2002-02-06 05:50:49] john_woodhouse@hammond-logistics.co.uk Evenin'... This morning I decided to try PHP for our company web site instead of VBScript. Imagine my delight to find PHP will handle SQL7 with the minimum of fuss... all it would take was <?php $hostname = "[IPADDRESS],[PORT]"; $username = "[USER]"; $password = "[PWD]"; $dbName = "[DATABASENAME]"; MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND."); mssql_select_db ( $dbName ); $query = "SELECT * FROM [TABLE]"; mssql_query ($query); ?> Or even lazier <? MSSQL_CONNECT("[IPADDRESS],[PORT]","[USER]","[PWD]"); mssql_select_db ([DATABASENAME]); mssql_query ("SELECT * FROM [TABLE]"); ?> Brilliant 15 lines of VBScript is 3 lines.. Imagine, then, my chagrin, for when I added the mssql_query(); statement I get a window saying PHP.EXE - Application Error.. The instruction at "0x00" referenced memory at "0x00", The memory could not be "read"... Is it me??? The setup I used was the windows installer but I put php_mssql.dll into c:\PHP and told the php.ini file where it was.. I also stuck the ntwdblib.dll into c:\windows\system32... Yes I know it should be c:\winnt but I changed it at setup... AAaaanyway... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15400&edit=1