View Single Post
Old April 4th, 2008, 08:59 AM
takwirira takwirira is offline
Authorized User
Join Date: Feb 2007
Location: , , .
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default Path to database

sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _

My connection string looks as above.

i have uploaded the site to the web server in a folder called Register. Register is in the root folder. However there is a folder called Search in which some aspx pages will need access to that same database.

My question is, how do I change the connection string to access the database either in the Register folder or in the root.




  search.aspx ****Search needs access to db2.mdb !! OR I can put db2.mdb in the root but I still wouldnt know how to put in the connection string.

I managed to do this on my local pc using the full file paths but this is not possible on the web server

Your help is greatly appreciated.