• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

DB Connection Problem

Hi,

I have an web application using ASP and Access.  

This is my DB connection string:
      filePath = Server.MapPath("database/demo.mdb")
      Set oConn = Server.CreateObject("ADODB.Connection")
      oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath

and this is the string that I close the connection when user log out:
oConn.close

My question is, why .ldb alway presents?  Thanks.
0
mcrmg
Asked:
mcrmg
1 Solution
 
alorentzCommented:
Either your opening the connection more than once, and not closing ALL connections, OR your never getting to the oConn.  The .ldb definitely disappears if done correctly.
0
 
mattisflonesCommented:
Hi mcrmg,
Because the DB is opened by your ADO...

Mattis
0
 
sybeCommented:
because you have the database opened as an application? The .lbd is there is something has opened it, that includes a desktop application. Maybe your collegue has it opened and went home?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
mcrmgAuthor Commented:
It is strange, that on my lcoal IIS, I never seen the ldb file, only when I oprn db in access.  But when I move this to server, ldb files created when I logged on..
0
 
QLJCommented:
Have you checked to see your security status for the access file?
Enable IUSR<computername> to have full control over the access files
See if it helps!
0
 
mcrmgAuthor Commented:
Hi,

I set permission for certain user, before user get in to the application, they will have to enter username and password that I set up on server.
0
 
QLJCommented:
Ok, then think u need to add in the password and UserID to the access database... even if it is null. Dun leave it to default!
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=...;User ID=[]; Password=[];"
0
 
mcrmgAuthor Commented:
I will post back....thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now