[HELP] Website (No connection to the Database.)

[yazuka21]

Hi guys.. I have a problem with my website configuration...
I already edit my xinc_config.
And I am using Plesk Host, I really don't know how I can fix this one.
Everytime I open my website it gives me alot of errors.

I'am 100% sure that the SQL Password "MY SQL PASSWORD" is correct then the "IP ADDRESS,1433" is also 100% correct

 Spoiler

define('MSSQL_HOST', 'IP ADDRESS,1433'); // MsSQL Host
define('ODBC_USER', 'sa'); //
define('ODBC_PASS', 'MY SQL PASSWORD'); //
$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER='.'IP ADDRESS,1433'.';', 'sa','MY SQL PASSWORD');

With Website error

 Spoiler

Warning: odbc_connect(): SQL error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied., SQL state 08001 in SQLConnect in C:\Inetpub\vhosts\flyff.net\httpdocs\includes\xinc _config.php on line 16

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\flyff.net\httpdocs\index.php on line 105

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\Inetpub\vhosts\flyff.net\httpdocs\index.php on line 105

Please help me

[Lumi]

Try to delete sa and mssql pw. (Leave it empty) It works me. :3

[yazuka21]

Originally Posted by ​Lumi

Try to delete sa and mssql pw. (Leave it empty) It works me. :3

Sorry :3
still the same .

[Sedrika]

Set Trusted_Connection=no; in your connection string.

Also open sql configurator on main destination and allow ip connections and instead of dynamic ports change it to 1433 fixed. After that restart SQL server on services and it should work after that.

[yazuka21]

Originally Posted by Sedrika

Set Trusted_Connection=no; in your connection string.

Also open sql configurator on main destination and allow ip connections and instead of dynamic ports change it to 1433 fixed. After that restart SQL server on services and it should work after that.

Sir You mean this ?

Originally Posted by Sedrika

Set Trusted_Connection=no; in your connection string.

Also open sql configurator on main destination and allow ip connections and instead of dynamic ports change it to 1433 fixed. After that restart SQL server on services and it should work after that.

I reviece a new website error I hope you can help me sir..

 Spoiler

Fatal error: Uncaught Error: Call to undefined function odbc_connect() in C:\Inetpub\vhosts\pixieflyff.net\httpdocs\includes \xinc_config.php:16 Stack trace: #0 C:\Inetpub\vhosts\pixieflyff.net\httpdocs\index.ph p(4): require_once() #1 {main} thrown in C:\Inetpub\vhosts\pixieflyff.net\httpdocs\includes \xinc_config.php on line 16

[Sedrika]

Also set at IPAll => TCP Dynamic Ports to 0 and now enable pdo_odbc in php or without the pdo. After it should work. And don't forget to restart the SQL Services again.

[yazuka21]

Originally Posted by Sedrika

now enable pdo_odbc in php or without the pdo. After it should work. And don't forget to restart the SQL Services again.

I'm sorry but I don't know where to locate this with Plesk host..

and there's no php.ini...

[Sedrika]

No clue. Never worked with plesk. You gotta find it but at the end it should done it's work.

[yazuka21]

Originally Posted by Sedrika

No clue. Never worked with plesk. You gotta find it but at the end it should done it's work.

I have new error sir I hope it can help..

 Spoiler

C:\Inetpub\vhosts\pixieflyff.net\httpdocs\includes \xinc_config.php on line 16

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\pixieflyff.net\httpdocs\index.ph p on line 111

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\Inetpub\vhosts\pixieflyff.net\httpdocs\index.ph p on line 111

This error shows when I changed PHP 7.0.17 to PHP 5.4.45..

With the error says there;s no database connection in index.php line 111 when I try to check that line it is 'checkDatabaseConnection' but there's already executed 'checkDatabaseConnection' in my database.

[Ecrypter]

Read the error, you should know and read the error were the error said. Plesk is easy.

[yazuka21]

Originally Posted by Ecrypter

Read the error, you should know and read the error were the error said. Plesk is easy.

I do all my best but I really don't know how to fix this :3

 Spoiler

C:\Inetpub\vhosts\pixieflyff.net\httpdocs\includes \xinc_config.php on line 16

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\pixieflyff.net\httpdocs\index.ph p on line 111

Warning: odbc_result() expects parameter 1 to be resource, null given in C:\Inetpub\vhosts\pixieflyff.net\httpdocs\index.ph p on line 111

Line 111 in index.php is checkDatabaseConnect but I already executed that sql..

[Ecrypter]

If you buy a plesk from phytonhost they have a tutorial on how to setup website on plesk panel also in sql server.