Access over UNC

[skiflyer]

I'm trying to connect to an access database over a UNC path (windows)... I can run an is_file, so I'm certain I'm seeing the file... but I can't seem to open the db...

Here's my connection string

$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=".DATABASE.";Mode=ReadWrite;Persist Security Info=False") or die("Could not connect to ".DATABASE);

Where DATABASE is just a constant defining my UNC path to the .mdb file.

Thanks,
Rob

 

[skiflyer]

Here's the answer to my own question... there's something funky in the ADODB COM connection in that the above always returns false, thereby triggering the die call, but in reality it succeeds and works just fine. So you need to use another form of error checking.... fun.

-Rob