Problem Connecting to Access Db from ASP

PriyaBabu · #1 (**permalink**) 09-27-03, 04:50

I have some ASP files on a server. There is also a different folder which contains a mdb. The folder doesnt have right to any user. Connection to the mdb is established through a connection string / DSN. The DSN is created on the server in which the files and the mdb lie. When running my site i get the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data

Could anyone help me in solving this issue as soon as possible.

Thank you,

Regards,
K. Sripriya

jlot6 · #2 (**permalink**) 09-28-03, 21:07

Are you sure you are giving the DSN the right user name and password

Code:

Rs.open “table1”, “DSN=data;uid=username;pwd=password”

If this doesn't help, can you display some of your sample code...

Bullschmidt · #3 (**permalink**) 09-30-03, 00:09

Yes it does sound like a problem with the connection string and/or DSN as the database apparently isn't being found.

janakireddy_g · #4 (**permalink**) 11-11-03, 14:20

Quote:

Originally posted by PriyaBabu
I have some ASP files on a server. There is also a different folder which contains a mdb. The folder doesnt have right to any user. Connection to the mdb is established through a connection string / DSN. The DSN is created on the server in which the files and the mdb lie. When running my site i get the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data

Could anyone help me in solving this issue as soon as possible.

Thank you,

Regards,
K. Sripriya

even i have the same problem ,in case if u get the solution pls e-mail me

janakireddy_g · #5 (**permalink**) 11-11-03, 14:20

Quote:

Originally posted by PriyaBabu
I have some ASP files on a server. There is also a different folder which contains a mdb. The folder doesnt have right to any user. Connection to the mdb is established through a connection string / DSN. The DSN is created on the server in which the files and the mdb lie. When running my site i get the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data

Could anyone help me in solving this issue as soon as possible.

Thank you,

Regards,
K. Sripriya

even i have the same problem ,in case if u get the solution pls e-mail me

janakireddy_g · #6 (**permalink**) 11-11-03, 14:22

Quote:

Originally posted by PriyaBabu
I have some ASP files on a server. There is also a different folder which contains a mdb. The folder doesnt have right to any user. Connection to the mdb is established through a connection string / DSN. The DSN is created on the server in which the files and the mdb lie. When running my site i get the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data

Could anyone help me in solving this issue as soon as possible.

Thank you,

Regards,
K. Sripriya

even i have the same problem ,in case if u get the solution pls e-mail me

PriyaBabu · #7 (**permalink**) 11-12-03, 05:42

If u r using an Access Db, instead of creating a DSN, user provider to connect to the Database which should solve ur problem. I removed the DSN and used provider to connect to the DB and the problem is solved.

Also ensure that the MDB file has full access while the folder doesn't have write access for the Internet guest account.

Regards,
K. Sripriya

myLittleTools · #8 (**permalink**) 11-12-03, 11:00

also check that the database is not open in MS Access software...

Internet Services

Web Development

Digital Marketing

Consumer Tech