mssql + PHP issue - URGENT.
Nikolai K. Bochev
n.bochev at grandstarco.com
Mon Apr 26 16:38:45 UTC 2010
Can you try connecting with tsql ?
I have been able to connect ot mssql 2008 std edition just fine, no really sure, but i think express has some protocols either missing or disabled by default.
Also, you should add an entry in /etc/freetds/freetds.conf ( or the appropriate config ) and use that entry as a connection string.
I can check the details on how i made it work tomorrow, since i am too lazy to log to work pc right now :F
I've just managed to convince the management to let us run Linux boxes as our new frontend webservers - they are ubuntu-server 9.10 boxes configured for fail over using heartbeat and DRBD.
Our database servers however have remained as Microsoft SQL 2008 servers.
The issue I am having is that with the testing of our webserver's I cannot seem to connect to an MS SQL 2008 Express db server, every time I get the error
"Warning : mssql_connect() [ function.mssql-connect ]: Unable to connect to server: 192.168.1.15,1433 in /shared/var/www/oursite/inc/oursite_dbcon.php on line 2
Could not connect to database: "
The PHP code used to connect is a standard connection string i.e.
"mssql_connect("192.168.1.15,1433","username","passw0rd") or die ("Could not connect to database: ".mssql_get_last_message());"
The web server has has 'apt-get install php5-sybase' run on it and apache restarted so the mssql.so object has been loaded - this is also confirmed by its presence on the output from phpinfo();.
I have disabled the firewall on the SQL2008 server - and can see the port 1433 listening on the test sql server (my workstation) from the webserver. I am also able to telnet to port 1433 on the SQL server from the webserver. The username and password are also correct - I have quadruple checked this.
I've been googling all afternoon and seem to be finding conflicting information regarding the ability of PHP to connect directly to an MSSQL database. Some sites seem to suggest you must use a DSN via an odbc connection but other sites suggest the old school connection string method should work fine just as you would if using mysql. I really don't want to start modfying the developers code, as far as I'm concerned this codebase worked fine under windows/iis so it should run in our new Linux environment.
If anyone can give me any clarification on this issue I would be very thankful as these servers are going to be racked this week and I do not want to have the powers that be decide we should revert to Windows Server / IIS.
Nikolai K. Bochev
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the ubuntu-server