• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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