ADODB Connection to Inventory.mdb

[2122002]

Dear All,

I have been struglling to connect to my database (inventory.mdb) located on "Stock\Admin\inventory.mdb" direcotry.

I have two folders "Admin" and "User". I do not have problem when I run "defaul_adm.asp" under the Admin folder where the .mdb is located, however, if i tried to run "default_usr.asp" under the User folder then I have problem to execute it becuase it search for the "Inventory.mdb" database.

Below is my code, please help me:

Sub Open_Database()
set dbInvent = Server.CreateObject("ADODB.Connection")
dbInvent.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Inventory.mdb") & ";"

End Sub


Dan

 

[DotNetGnat]

what is the error you are getting...make sure the folder has the correct permissions...
did you try:

Server.MapPath("./Inventory.mdb")

-DNG

 

[lennitw]

Try:

Server.MapPath("..\Admin\Inventory.mdb")

Suggestion:
If you are going to access this DB from multiple pages in varying folders, you should create a single page (connect.asp) and put your connect string there. You would then include that file (<!--#include file="../Admin/connect.asp"-->) at the top of every page that needs to connect to the DB.

 

[Sheco]

Think about a web site where all of the graphics are stored in an /images folder... other pages in different sub directorires will have different paths to the graphics directory... the same will be true of your .mdb file.

 

[2122002]

Thanx. However, it doens't work. I have check on the folder, it has read/write permission. "C:\Inetpub\

http://wwwroot..."

directory.

Any other method? or Any clue on using DNS?



Dan

 

[lennitw]

Post the full code. It is probably how you call the sub. If it works when default page is in same DIR as DB, then the DB DIR has read/write so that shouldn't be a question.