Unspecified Error

[RahulChavan]

Hello
I am using the following code which is running on a remote web site.
I am getting an Unspecified Error when I try to open the connection. The code is as follows

Set conn = Server.CreateObject("ADODB.Connection")
dbPath = Server.MapPath("Database/CommonDB.mdb")
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & ";Persist Security Info=False"
conn.open

Can anybody help

 

[Kodo]

response.write out your dbPath to make sure it's pointing to the write place. then make sure IUSR_[machine_name] has modify rights to the db folder.

 

[RahulChavan]

response.write out your dbPath to make sure it's pointing to the write place. then make sure IUSR_[machine_name] has modify rights to the db folder.

I assume dbPath and user rights cannot be the issue as the site works most of the time . But once in 3-4 days it gives this error

 

[Kodo]

could be your connections are not being closed.
Make sure you are doing

Conn.close
set Conn=nothing

when you're done with the connection