[Help] Can't connect to database on Website

[jhomz014]

Hi, I have a website and already set the TCP/IP on the server but still I can't make it connect the website on the server.

I tried this methods:

 Spoiler

define('ODBC_USER', 'sa'); //
define('ODBC_PASS', 'SQLPASSWORD'); //
$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER=SERVERIP,1433', ODBC_USER, ODBC_PASS);

 Spoiler

define('ODBC_USER', ''); //
define('ODBC_PASS', ''); //
$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER=SERVERIP,1433', ODBC_USER, ODBC_PASS);

 Spoiler

define('ODBC_USER', 'sa'); //
define('ODBC_PASS', 'SQLPASSWORD'); //
$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER=SERVERNAME\SQLEXPRESS', ODBC_USER, ODBC_PASS);

 Spoiler

define('ODBC_USER', ''); //
define('ODBC_PASS', ''); //
$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER=SERVERNAME\SQLEXPRESS', ODBC_USER, ODBC_PASS);

But nothing worked.
Any suggestions on how to make it work?
The error I got is this:

 Spoiler

[19-May-2020 17:58:52 Asia/Manila] PHP Warning: odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQLConnect in /home/***/public_html/includes/xinc_config.php on line 17
[19-May-2020 17:58:52 Asia/Manila] PHP Warning: odbc_exec() expects parameter 1 to be resource, bool given in /home/***/public_html/index.php on line 30
[19-May-2020 17:58:52 Asia/Manila] PHP Warning: odbc_result() expects parameter 1 to be resource, null given in /home/***/public_html/index.php on line 32

[xTwiLightx]

My guess is that your system does not have the "SQL Server" driver installed.

You might have to check this one:


After installation, you can replace "SQL Server" with "ODBC Driver 17 for SQL Server" in your connection settings

[jhomz014]

Originally Posted by xTwiLightx

My guess is that your system does not have the "SQL Server" driver installed.

You might have to check this one:


After installation, you can replace "SQL Server" with "ODBC Driver 17 for SQL Server" in your connection settings

The server is all running and up. Can connect players in-game but only the website can't.
Also the server is running on Windows 2012 R2 Server.

[xTwiLightx]

Originally Posted by jhomz014

The server is all running and up. Can connect players in-game but only the website can't.
Also the server is running on Windows 2012 R2 Server.

I am talking about the website and was referring to the error message provided, which clearly shows linux paths...