Unspecified Error (1 Viewer)

R

RahulChavan

Guest

• Jul 6, 2006

• #1

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

"The Shoe"

Local time

Yesterday, 20:23

Joined

Jan 20, 2004

Messages

707

• Jul 6, 2006

• #2

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.

 

R

RahulChavan

Guest

• Jul 6, 2006

• #3

Kodo said:

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.

Click to expand...

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

"The Shoe"

Local time

Yesterday, 20:23

Joined

Jan 20, 2004

Messages

707

• Jul 8, 2006

• #4

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