Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access and web pages
- Thread starter Ladyhawk
- Start date
- Thread starter
- #3
- Thread starter
- #5
I'll have to do this later on in the week, but look up the web.config file in the net help, and it will tell you where to put the info. It's added like: add key, or something close. You set
<appSettings>
<add key="Orders"
value="server=myserver; database=mydb; user id='myuser'; password='mypwd'; integrated security=false;"/>
</appSettings>
If you set this up as an ado access connection, you would have the database name and path in here as well. This is for sql server. But you get the idea.
Found this in help. I hope this helps you.
<appSettings>
<add key="Orders"
value="server=myserver; database=mydb; user id='myuser'; password='mypwd'; integrated security=false;"/>
</appSettings>
If you set this up as an ado access connection, you would have the database name and path in here as well. This is for sql server. But you get the idea.
Found this in help. I hope this helps you.
- Thread starter
- #7
When you connect to an Access database, you usually add the path of the database. For example, database=c:\mydir\mydb.mdb.
If I am on a web server, I am not going to know c:\mydir. All I am going to know is that the database is in the same directory as the script. But how can I specify that the database is located in the same directory as the script?
Ladyhawk.![[idea]](/data/assets/smilies/idea.gif "[idea] [idea]")
** ASP/VB/Java Programmer **
If I am on a web server, I am not going to know c:\mydir. All I am going to know is that the database is in the same directory as the script. But how can I specify that the database is located in the same directory as the script?
Ladyhawk.
** ASP/VB/Java Programmer **
juliaroberts
Programmer
declare an element in your app.config to your path to the database. when the app loads, read this value and set the connection string.
- Thread starter
- #9
merlyn2450
Programmer
Use the relative path with the HttpContext.Current.Server.MapPath function (as in legacy ASP).
Ex: path = HttpContext.Current.Server.MapPath("./data/db1.mdb"
Ex: path = HttpContext.Current.Server.MapPath("./data/db1.mdb"
;- Thread starter
- #11
- Status
Similar threads
- Locked
- Question
- Locked
- Question