Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Struggles with OLE DB Connections


Message #1 by "Peter Ferber" <peterfrb2@y...> on Fri, 17 Jan 2003 03:03:22
Hello:

I am using the book "ASP Databases" by John Kaufman, and I'm struggling 
with chapter 6, Connections.

I have a DSN connection to the sailors database, and I can generate an ASP 
page with a connection when I say "DSN=Sailors".  I can also generate 
output with the following string:

"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=<path>\sailors.mdb"

But I get the error when I attempt to use OLE DB.  This is my string:

"Provider=Microsoft.Jet.OLEDB.3.51;Data Source=<path>\sailors.mdb"

...and this is my error:

Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the 
file '<path>\sailors.mdb'. It is already opened exclusively by another 
user, or you need permission to view its data.

Since the other methods do work, and I can go back and forth between them; 
I know that permissions are not at issue.  Also, this is my personal PC, 
and I know for certain that no one else is using this computer.

Any ideas or suggestions?
--Peter Ferber

  Return to Index