Posted by Mark Rees on 10/20/05 13:44

> I am trying to connect to Sage Line 50 data files through odbc
> driver (SageLine50v8) from php5 (running on windows xp pro) by
> odbc_connect().
> Unfortunately I can not find right connection string and I get back an
> error:
> "SQL error: Cannot find all files in data path, SQL state 08001 in
> SQLConnect"
> This is what I am trying to do now:
>
> $connection_string="SageLine50v8";
> $conn=odbc_connect($connection_string,'marcin','mypassword','');
>
> I am sure there is the way to connect to this data because I have
> successfully connected from Excel using the same odbc driver.

Have a look here :
http://www.connectionstrings.com/

I only know about Sage line 500, but that runs on SQL server (for example).
So you will need the odbc connection string to the underlying database (or
inbuilt PHP functions such as mysql_connect). Your connection string there
looks like the name of the database. It needs to look more like (MySQL
example)

DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPass
word;OPTION=3;"

[Back to original message]