/    Sign up×
Community /Pin to ProfileBookmark

this combo: php on a windows2003 + ms access on a 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-SERVERC$omxxafta.mdb”) .” ;DefaultDir=”. realpath(“POS-SERVERC$om”);

this is the script used for samba share, it didnt work:
//$db_connstr = “DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=”. realpath(“nas1workwareOrderManagerxxafta.mdb”) .” ;DefaultDir=”. realpath(“nas1workwareOrderManager”);

What can I do? any adcvices will be apreciated/.

to post a comment
PHP

0Be the first to comment 😎

×

Success!

Help @sugar2 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.20,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...