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
|