Hosting

04/18/2020 19:58 aoyamananami#1

hello im here again can someone help me how do i connect the other hosting server in website. Example the server files is in the other hosting and the other is in other hosting server.

Quote:

$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER=WIN-SERVER\SQLEXPRESS', ODBC_USER, ODBC_PASS);
$_CONFIG['db_databases'] = array( // Datenbanken
'acc' => 'ACCOUNT_DBF',
'chr' => 'CHARACTER_01_DBF',
'web' => 'WEBSITE_DBF',
'log' => 'LOGGING_01_DBF',
);

do i have to edit the sql server and link the sql server of the other hosting server please help.

04/18/2020 20:48 Tweeney#2

SERVER=IP, 1433

Then on your SQL Configuration allow ip connection and change the ports to 1433 then restart your sql server

dont forget to open the firewall ports needed

04/18/2020 21:30 aoyamananami#3

Quote:

Originally Posted by Tweeney

SERVER=IP, 1433

Then on your SQL Configuration allow ip connection and change the ports to 1433 then restart your sql server

dont forget to open the firewall ports needed

Thank you for the respond ill try this.

04/19/2020 12:16 Ecrypter#4

Quote:

Originally Posted by aoyamananami

hello im here again can someone help me how do i connect the other hosting server in website. Example the server files is in the other hosting and the other is in other hosting server.

do i have to edit the sql server and link the sql server of the other hosting server please help.

PHP Code:


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

$_CONFIG['db_databases'] = array( // Datenbanken

'acc' => 'ACCOUNT_DBF',

'chr' => 'CHARACTER_01_DBF',

'web' => 'WEBSITE_DBF',

'log' => 'LOGGING_01_DBF',

);

you need to put the ip of the server if the files is on another server like cpanel. check my guide