View Single Post
  #1 (permalink)  
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

Reply With Quote