Re: ASP to PHP (Secure MS Access connection)..

I've never handled secured db's, but in windows' control panel, in the ODBC applet where you define DSN, you can also define the system db for each db. When connecting in PHP your string has DSN, user and password, like: $dsn="AnyDSN"; $user="Joe"; $pass="foobar"; $conn = odbc_connect($dsn,$user,$pass); You neither can (as far as I know) nor need to pass any other arguments since the rest of the DSN definition is done on the control panel. That is, the DSN points both to your .mdb and, if necesary, your .mdw, so you don't have to say anything from PHP. Gonzalo. > I'm trying to convert an ASP site to PHP, and my problem is this: > I've set up the the DSN on my machine to utilize the built-in odbc functions > as I would any Access DB. Because this is a "secure" db, i'm supposed to > reference the MDW file as opposed to the MDB... Well I can't seem to get it > to work. > Here is the connection string thats used in ASP: > Application("WCSChamber_ConnectionString") = > "DSN=WCSChamber;DBQ=D:\Clients\WCS\wcsdat.mdb;DriverId=281;FIL=MS > Access;MaxBufferSize=2048;PageTimeout=5;SystemDB=D:\Clients\WCS\wcs.MDW;" > Does anyone have any idea how i can connect to this with PHP? > Any tips would be appreciated.. thanks.