connecting datebase

[zoglchaim770]

I am a begginer
I connected microsoft access datebase like this:
1. used "odbs", system DSN

2.

dim objconn
set objconn=server.CreateObject ("ADODB.connection&quot
objconn.ConnectionString = &quot;<name>&quot;
objconn.open

and I get this error
Error Type:
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.
/school.asp, line 12(In objconn.ConnectionString = &quot;<name>&quot;!)
I don't undestand. My datebase is not in use, it's closed
Does it make a differeents, what kind of format do you use for access datebase 2000 format, 2002 format

 

[spazman]

try this

strConnection = &quot;DSN_FOR_MY_DB&quot; <-- DSN Name
Set dbConn = Server.CreateObject(&quot;ADODB.Connection&quot
dbConn.Open strConnection

 

[zoglchaim770]

no, didn't work
some how i get the same message.
Any ideas?

 

[zoglchaim770]

maybe set objconn=nothing at the end of the code does not work and therefore datebase is allways open
Any Ideas

 

[DreXor]

see threads and FAQ

http://www.tek-tips.com/faqs.cfm?spid=333&sfid=178

http://www.tek-tips.com/faqs.cfm?spid=333&sfid=976

http://www.tek-tips.com/faqs.cfm?spid=333&sfid=2120