[sugar2]

HI, i have a dsn less connection to a ms access database with php.
Im using this connection script, but actually the database is not in the program dir, it is in the network drive y:\
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("Crafta.mdb") ." ;DefaultDir=". realpath(".");

Im trying to do like this: with no results...
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("y:\Crafta.mdb") ." ;DefaultDir=". realpath("y:");

Also I tried this with no results: realpath("\\nas1\workware\OrderManager\Crafta.mdb")
and yes, its in the same workgroup...

NOte: The \\nas1 its a unix shared dir, not a windows share

Thanks in advance.

[ringfinger]

Since its "DNS-less" have you tried \\x.x.x.x\Crafta.mdb ?

[IcemanND]

DSN= Data Source Name
DNS= Domain Name Service

DSN <> DNS




Have you tried it on a windows share, just to be sure it's not a issue with unix

This post has been edited by IcemanND: 19 May 2006 - 08:56 PM

[sugar2]

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

[tain]

Has this db ever worked when stored on the unix server? Please verify that it will work there locally and then try accessing it remotely.

[ringfinger]

IcemanND, on May 19 2006, 08:55 PM, said:

DSN= Data Source Name
DNS= Domain Name Service

DSN <> DNS




Have you tried it on a windows share, just to be sure it's not a issue with unix

My bad.