Cannot open Connection

D

Diesel

Contributor
Joined
Aug 18, 2003
Messages
662
I was fiddling 'round with ASP, created a web form, connection, data adapter and dataset, all visually and then bound some textboxes. Now I keep getting this error:
The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\MattsApp1\JKDB.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

I've created a VB interface that works fine with the database, why doesn't it open using asp? A security problem? Help!
 
HI
Actually i think that you are using the database connections in the application but at sme point forget to close the connection. This type of error occures because you have opened a connection exclussively and forget to close it.
 
Yeh, the only code I have in the program right now is in the Load_Page sub and it is this

OledbConnection1.open() <-- I get the error here
Oledbdataadapter.fill(dataset1, "property")
OledbConnection1.close()

So, the connection is not opened programmatically, and if I delete the open mothed and just leave the fill command, it still gives the same error
 
Back
Top