sage odbc connection

[eSc]

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','my password','');

I am sure there is the way to connect to this data because I have
successfully connected from Excel using the same odbc driver.

Please advise if you can...

[Mark Rees]

> 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','my password','');

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;"

[eSc]

I've made for myself file test.udl where I have this:

Provider=MSDASQL.1;Password=mypassword;Persist Security Info=True;User
ID=marcin;Data Source=SageLine50v8;Mode=Read

and when I am testing connection diectly from windows (MDA OLE DB)- it
works but if I am using this as my connection string in php it gives me
an error.
ps. sage (line 50 v8) is not working on real dbms system - this odbc
driver let you read (only) the data store in their data files.