Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sugar
Starting Member
10 Posts |
 Posted - 2006-05-20 : 14:43:40
|
| hi, i didnt know where exactly to post this question: I can link Sql server tables to my access database, but i cant link my access tables to from the sql server database, may be because the ms access database its stored on a unix samba share?hi, i didnt know where exactly to post this question: This is the scneario, i have a unix samba share in my network, there are all the office stuff, including a share to a Ms access database wich its accessed from many windows clients.Now i need to access that ms access database from http, so i installed apache+php in a windows server in the same workgroup, i did succesfully test when the ms access database was on the local windows server, but once i tried with the database in the actual server it didnt worked, i found few scripts in google about odbc, ole, and dsn-less connections, all of them worked when database resides in the local machine, but don work when database is in the actual unix samba share.This is the script used with local machine test://$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("\\\\POS-SERVER\C$\om\xxafta.mdb") ." ;DefaultDir=". realpath("\\\\POS-SERVER\C$\om");this is the script used for samba share, it didnt work://$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("\\\\nas1\workware\OrderManager\xxafta.mdb") ." ;DefaultDir=". realpath("\\\\nas1\workware\OrderManager");What can I do? any adcvices will be apreciated/. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-05-21 : 07:43:02
|
| see this www.connectionstrings.com |
 |
|
|
|
|
|
|
|
this combo: php on a windows2003 + ms access on a