How do we set a ODBC connection from our cPanel to a windows server?
I've searched every where but all I find is tutorials for plesk or websitepanel
How can we do that?
I've tried this:
* On servername I've placed my IP ADDRESS, is this correct?
From:
PHP: odbc_connect - Manual
But, no success...
I'm using WHM with EasyApache 4 (mssql and odbc extensions are installed)
I have no idea how to use it... On Plesk they say all you gotta do is add a odbc remote connection (throught a gui), but on cPanel I have no idea how to do it...
I know there is a odbc.ini file but I dont know how to use it, what to write on it.
Please, help me.
Thank you.
I've searched every where but all I find is tutorials for plesk or websitepanel
How can we do that?
I've tried this:
Code:
<?php
$connection_string = 'DRIVER={SQL Server};SERVER=<servername>;DATABASE=<databasename>';
$user = 'username';
$pass = 'password';
$connection = odbc_connect( $connection_string, $user, $pass );
?>
From:
PHP: odbc_connect - Manual
But, no success...
I'm using WHM with EasyApache 4 (mssql and odbc extensions are installed)
I have no idea how to use it... On Plesk they say all you gotta do is add a odbc remote connection (throught a gui), but on cPanel I have no idea how to do it...
I know there is a odbc.ini file but I dont know how to use it, what to write on it.
Please, help me.
Thank you.
Last edited by a moderator: