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=" & _
Server.MapPath("db2.mdb")

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.

Thanks

Illustration

\Root
--Register
  register.aspx
  db2.mdb

--Search
  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.

Thanks