470,832 Members | 2,085 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,832 developers. It's quick & easy.

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

Oct 20 '05 #1
2 8123
> 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;"

Oct 20 '05 #2
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.

Oct 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Rshah | last post: by
reply views Thread by marc.holt | last post: by
2 posts views Thread by franc sutherland | last post: by
2 posts views Thread by Beany | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.