this combo: php in a windows2003 + msaccess in a samba unix 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.md b") ." ;DefaultDir=".
realpath("\\\\nas1\workware\OrderManager");

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

In news:C3214B5B-B60A-401F-96FC-(E-Mail Removed),
Aldo <(E-Mail Removed)> stated, which I commented on below:
> 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.md b") ."
> ;DefaultDir=". realpath("\\\\nas1\workware\OrderManager");
>
> What can I do? any adcvices will be apreciated/.

Machines in a workgroup will need to be accessed via IP address because of
the way the Browser service works. In a workgroup there is no master
browser. Try using the IP address of NAS1 instead of the name "NAS1" and see
if that works.

--
Ace

This posting is provided "AS-IS" with no warranties or guarantees and
confers no rights.

Having difficulty reading or finding responses to your post?
Instead of the website you're using, I suggest to use OEx (Outlook Express
or any other newsreader), and configure a news account, pointing to
news.microsoft.com. This is a direct link to the Microsoft Public
Newsgroups. It is FREE and requires NO ISP's Usenet account. OEx allows you
to easily find, track threads, cross-post, sort by date, poster's name,
watched threads or subject.

It's easy:
How to Configure OEx for Internet News
http://support.microsoft.com/?id=171164

Ace Fekay, MCSE 2003 & 2000, MCSA 2003 & 2000, MCSE+I, MCT, MVP
Microsoft MVP - Directory Services
Microsoft Certified Trainer

Infinite Diversities in Infinite Combinations
Assimilation Imminent. Resistance is Futile
"Very funny Scotty. Now, beam down my clothes."

The only thing in life is change. Anything more is a blackhole consuming
unnecessary energy. - [Me]

The thing was solved.
I changed the user that apache uses to logon, to a samba authorized user
acconunt, not the system account, and with this string:

$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".
realpath("\\\\nas1\\workware\\OrderManager\\xxafta .mdb") ." ;DefaultDir=".
realpath("\\\\nas1\\workware\\OrderManager");

thanks!

In news:03EA020A-B3CD-43DD-8993-(E-Mail Removed),
Aldo <(E-Mail Removed)> stated, which I commented on below:
> The thing was solved.
> I changed the user that apache uses to logon, to a samba authorized
> user acconunt, not the system account, and with this string:
>
> $db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".
> realpath("\\\\nas1\\workware\\OrderManager\\xxafta .mdb") ."
> ;DefaultDir=". realpath("\\\\nas1\\workware\\OrderManager");
>
> thanks!

Glad to hear!

And thanks for posting the resolution. :-)

Ace

Now, i think i can do any conventional type of database connection... what
should i use for faster response and performance?
ODBC? OLE? DSN-LESS?... or may be linking the access databse to the SQL
Server i have installed on the web server?, what I really wish its to have a
faster querying of the MS access database without compromising the
performance of Our SQL Server database application.

There are 2 machines involved:

Mahcine1:
Dual Core Unix Server
Samba Server
MS Access Database

Machine1:
Dual Core Windows Server
Sql Server
Apache and PHP Server

Thanks in advance.

In news:7F6FA477-0D06-4D50-A99E-(E-Mail Removed),
Aldo <(E-Mail Removed)> stated, which I commented on below:
> Now, i think i can do any conventional type of database connection...
> what should i use for faster response and performance?
> ODBC? OLE? DSN-LESS?... or may be linking the access databse to the
> SQL Server i have installed on the web server?, what I really wish
> its to have a faster querying of the MS access database without
> compromising the performance of Our SQL Server database application.
>
> There are 2 machines involved:
>
> Mahcine1:
> Dual Core Unix Server
> Samba Server
> MS Access Database
>
> Machine1:
> Dual Core Windows Server
> Sql Server
> Apache and PHP Server
>
> Thanks in advance.

Sorry, I'm not really a database person but would imagine that SQL using
ODBC is much faster than any Access database I've seen. But then again, I
would suggest to test it out or better yet, post this question into the SQL
newsgroups to get an expert response.

:-)

Ace