sage odbc connection

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I am trying to connect to Sage Line 50 data files through odbc
driver (SageLine50v8) from php5 (running on windows xp pro) by
Unfortunately I can not find right connection string and I get back an
"SQL error: Cannot find all files in data path, SQL state 08001 in
This is what I am trying to do now:


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...

Re: sage odbc connection

Quoted text here. Click to load it

Have a look here :

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


Re: sage odbc connection

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.

Site Timeline