DB Path

[WestView]

Hello All,

I'm trying to create a community calendar using some code I discovered in a tutorial I found on Macromedia's site. [link]http://www.macromedia.com/devnet/mx/dreamweaver/articles/aspnet_calendar.html[/url]

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Xml" %>
<script runat="server">

DataSet ds = new DataSet();
protected void Page_Load(Object Src, EventArgs E)
{
	string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ Server.MapPath("aspnet_calendar.mdb") +";";
	string sql = "select * from events";

The connection path is something like: c:\root\dir1\dir2\database\aspnet_calendar.mdb

I've written it dozens of ways and nothing works. Help!!!

Thanks for any/all advice,

- Tom

 

[ca8msm]

The Server.MapPath allows you to pass a virtual path so you can get the full path returned. e.g.

If you have an application named MyApp in thw

http://wwwroot

folder and your db is stored in the "db" folder, you would have:

Application: c:\inetpub\

http://wwwroot\MyApp

Database: c:\inetpub\

http://wwwroot\MyApp\db\MyDb.mdb

Then you could assign the datasource using:

Dim DBPath as String = Server.MapPath("db/MyDb.mdb")

Hope this helps.


----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.