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.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
