Problem with connecting Access Database

[AnilNe]

Dear Friends,
I used to have a ASP page to display data from a Access Database. It used to work well before, but now it's not working. I have not done any change in the coding but it is showing the following error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

Can anyone help me out? Thanks in advance.
With Regards,
Anil

 

[DreXor]

sounds like the odbc pointer or the dsnless pointer is pointing to a DB that's been moved or deleted.


DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!

 

[wangdong]

Check your database name and your MDB file.

 

[AnilNe]

Dear Friends,
There has been no change in MDB file and I have not changed anything in it.
Waiting for the reply.
Anil

 

[DreXor]

you may not have changed the db , but either the db has been moved, the odbc pointer is pointing elsewhere than where the db is, or, the connection string set up where-ever is telling ADO to look in the wrong place for the DB, and the "wrong place" could be a typo in the filename... which can include if the file was renamed for any reason.

basically something has had to change since it was functional. whether it be software added (service patches for example), config changes in odbc, a registry rollback that might have lost the odbc information, code changes, and/or (filename/folder/tree) name or structure alterations.

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!