Connecting to remote server/sage using php?

[MercJones]

Hi there.

Just wondering if any of you have any suggestions/experience on connecting to sage using php.

I know you need the odbc extension, which ive added to php.ini, and then ive done sudo aptitude install php5-odbc, which phpinfo() has picked up, but im trying to connect and get:

SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect

so I dont know if I need another driver or whatever?

Also, i read you may need to edit odbc.ini in /etc/ this exists but is empty.

The problem gets worse becuase you normally use code similar to:

<?php
$rConn = odbc_connect("SageLine50V10", "user", "pass");

$rRes = odbc_tables($rConn);

odbc_result_all($rRes);
odbc_close($rConn);
?>

but we want to connect to a remote IP, instead of one on the same server running php.

Any ideas please?

Cheers

[RohanShenoy]

Did you add the data source using the instructions found at http://www.w3schools.com/php/php_db_odbc.asp ?

[MercJones]

Hi there. Yeah the datasource was already available and working.

Cheers