2. PHPRunner General questions
  3. [SOLVED]  Connecting to MSSQL DB from LAMP server (connection string)
This topic is locked
[SOLVED]

 Connecting to MSSQL DB from LAMP server (connection string)

 		3/13/2014 10:02:27 PM
PHPRunner General questions
W
 wijninga author

Hi,
I installed a LAMP server, got the sybase and freetds installed, connecting to mssql through isql and tsql work flawlessly. When checking PHP it actually says the mssql is installed.
However, I do get the following error when using a PHPRunner created site:
Warning: mssql_connect(): Unable to connect to server: www.myserver.com in /usr/share/nginx/html/include/dbconnection.mssql.unix.php on line 8
Fatal error: in /usr/share/nginx/html/include/dbconnection.mssql.unix.php on line 10
Now I think this has to do with the line in /include/dbcommon.php: $ODBCString = "Provider=SQLOLEDB;Server=
What should I put in for Provider? SQLOLEDB doesn't work and FreeTDS doesn't work either.
Any suggestions?
Admin 3/14/2014

If you are posting the actual error message here you need to replace www.myserver.com in your connection string with correct MS SQL Server address.