Database connection vanished after windows update

[MatthewP]

I have a bunch of php scripts that connect to a MS access database. These all worked fine until an update of the windows server 2003 software, now they dont

The connection script is simple:

$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=N:\\Shared\Database\db2_3_be.mdb;user=Matt;pass=password;") or print "cant open connection"

Im suddenly getting cant open connection messages.

User and password are correct.
I can access the database using MS access itself.
I am wondering if it is to do with user permissions. Clicking on the database and going to properties->security has a few users - Administrators, Everyone, SYSTEM and users. I have a vague recollection of there once being something else in there - web users or internet or something. This was set up four years ago though, I cant really remember.

Any ideas?
Thanks,
Matt

 

[mrdenny]

Is the N drive a local drive or a mapped drive? Maybe the IIS process doesn't have the drive mapped any more. If it's a mapped drive it's better to access it via the network share as the mapped drive can drop aware for no reason.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog