dsn workaround on PEAR::DB

need help to figure this out!

normally, we use dsn to make a dbase connection in PEAR. i'm using odbc/ms access, to be specific. here's the code i'm using in php 4.3.2 on IIS5:



and i got a connection to my C:access.mdb

what about if i don't have a dsn for my access db file? is there a way to directly point PEAR to access.mdb? i tried the dsn less way



but failed...

any idea?

don't think you can use it without dns..

anyway, why don't you make a dns file from your php script?


and btw, DONT post the same question in more than one forum...

I know this thread has been around awhile, but it the first one that came up on google when I was looking for the answer to the same question so I figure I would post the solution. If you use the below string, your connection should work. The problem is that PEAR:B parses out the (*.mdb), puts whatever is before it in as the protocol and hence it doesn't work. But if you tick it into parsing in an prior value that is before a set () it works!
Example:
$dsn ="odbc(access)://tcp()driver=Microsoft Access Driver (*.mdb);dbq=C:\Access.mdb";