p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   ASP.NET 2.0 Basics (http://p2p.wrox.com/forumdisplay.php?f=136)
-   -   Path to database (http://p2p.wrox.com/showthread.php?t=67147)

takwirira April 4th, 2008 08:59 AM

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


takwirira April 4th, 2008 09:01 AM

Before you ask, I cant put them in the same folder because of the web config files because im using forms authentication.

Thanks

takwirira April 4th, 2008 09:25 AM

        sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
        Server.MapPath("/Register/db2.mdb")

Thanks, This is now resolved



All times are GMT -4. The time now is 08:35 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.