Re: [PHP-WIN] PHP connecting to MSSQL

2009-03-30 Thread Sascha Meyer
Hi Alf, your local SQL Server is probably listening on another port ... perhaps you could try the following in a DOS prompt: netstat and netstat -n The first should give you all open local ports with descriptions to the port if a default port was used. The second will give you all open port

Re: [PHP-WIN] PHP connecting to MSSQL

2009-03-30 Thread Alf Stockton
Baboucarr Sanneh wrote: okay try including the port number for the mssql server (I.e 1433) in the connection string..that also can be the problem somethimes and Sasha Meyer said: > just a guess, are you using any kind of firewall (application or port based) > on your computer? Could you try a

Re: [PHP-WIN] PHP connecting to MSSQL

2009-03-30 Thread Sascha Meyer
Hi Alf, just a guess, are you using any kind of firewall (application or port based) on your computer? Could you try a "telnet localhost 1433" to check if this works? Regarding php.ini changes: have you restarted the web server's services after changing? Another source for an alternative way t

Re: [PHP-WIN] PHP connecting to MSSQL

2009-03-30 Thread Alf Stockton
Sascha Meyer wrote: Hi Alf, have you checked the comments on the php.net page (http://us.php.net/mssql_connect)? These are really helpful when it comes to troubleshooting. Yes I have. In fact that was where I got the original code. One setting I remember to have changed in my environment w

Re: [PHP-WIN] PHP connecting to MSSQL

2009-03-30 Thread Sascha Meyer
Hi Alf, have you checked the comments on the php.net page (http://us.php.net/mssql_connect)? These are really helpful when it comes to troubleshooting. One setting I remember to have changed in my environment was the following php.ini entry: [CODE] mssql.secure_connection=off [/CODE] Could y

Re: [PHP-WIN] PHP connecting to MSSQL

2009-03-30 Thread Alf Stockton
John Mertic wrote: Which version of mssql are you connecting to? My version number is 8.00.194 RTM Developer Edition -- Regards, Alf Stocktonwww.stockton.co.za You have many friends and very few living enemies. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, vi