Webconfig Connection String

[Paul W Smith]

My application uses two ways to connect to the Access db:

Programtically:

Dim sDBPath = "Data Source=D:\MCCL\AccessDB\NewMCCL.mdb;"
Dim sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & sDBPath
Dim myConnection As New OleDbConnection(sConnString)

By Declaring:

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/NewMCCL.mdb"
SelectCommand="SELECT * FROM [web_MatchReportingByWeekID]">
</asp:AccessDataSource>
What entry do I put into my webconfig file so I can call it from within my
code?

How do I use this for both types of the above versions?

PWS

[Phil H]

On 27 Oct, 17:13, "Paul W Smith" <[e-mail]:

My application uses two ways to connect to the Access db:

Programtically:

Dim sDBPath = "Data Source=D:\MCCL\AccessDB\NewMCCL.mdb;"
Dim sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & sDBPath
Dim myConnection As New OleDbConnection(sConnString)

By Declaring:

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/NewMCCL.mdb"
SelectCommand="SELECT * FROM [web_MatchReportingByWeekID]">
</asp:AccessDataSource>

What entry do I put into my webconfig file so I can call it from within my
code?

How do I use this for both types of the above versions?

PWS

It appears from your two declarations that you have two copies of the
file NewMCCL.mdb in different locations.

Assuming that when you deploy the site it will be in "~/App_Data/
NewMCCL.mdb" it would be simpler to modify the code for sDBPath to:

sDBPath = "D:\Data Source=" & Server.MapPath("~/App_Data/
NewMCCL.mdb;")

Unless the datafile name is likely to change it isn't worth putting it
in web.config because the entries won't be the same for
AccessDataSource1 and MyConnection (the latter requires a full
connection string whereas the former only needs the datafile path).

HTH

[=?Utf-8?B?TWlsb3N6IFNrYWxlY2tpIFtNQ0FEXQ==?=]

Howdy,

web.config:

<connectionStrings>
<add name="myConnectionString"
connectionString="server=whateever;datasource=blab la"/>
</connectionStrings>

aspx page:

<asp:AccessDataSource runat="server" ID="ds"
ConnectionString="<%$ ConnectionStrings:myConnectionString %>">
</asp:AccessDataSource>
vb.net code:

Dim connectionString As String = _
ConfigurationManager.ConnectionStrings("myConnecti onString").ConnectionString

ds.ConnectionString = connectionString

Hope this helps
--
Milosz
"Paul W Smith" wrote:

My application uses two ways to connect to the Access db:

Programtically:

Dim sDBPath = "Data Source=D:\MCCL\AccessDB\NewMCCL.mdb;"
Dim sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & sDBPath
Dim myConnection As New OleDbConnection(sConnString)

By Declaring:

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/NewMCCL.mdb"
SelectCommand="SELECT * FROM [web_MatchReportingByWeekID]">
</asp:AccessDataSource>
What entry do I put into my webconfig file so I can call it from within my
code?

How do I use this for both types of the above versions?

PWS

[Paul W Smith]

>sDBPath = "D:\Data Source=" & Server.MapPath("~/App_Data/NewMCCL.mdb;")

Are you sure about the line above, because I cannot get it to work.

Where did you get the "D:\" from?

[Mark Rae [MVP]]

"Paul W Smith" <pw*@NOSPAM.twelve.me.ukwrote in message
news:ex*************@TK2MSFTNGP04.phx.gbl...

sDBPath = "D:\Data Source=" & Server.MapPath("~/App_Data/NewMCCL.mdb;")

Are you sure about the line above, because I cannot get it to work.

Where did you get the "D:\" from?

Maybe from the third line of your OP...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Phil H]

On 27 Oct, 20:45, "Paul W Smith" <[e-mail]:

sDBPath = "D:\Data Source=" & Server.MapPath("~/App_Data/NewMCCL.mdb;")

Are you sure about the line above, because I cannot get it to work.

Where did you get the "D:\" from?

Yes, I beg your pardon. It should have been:

sDBPath = "Data Source=" & Server.MapPath("~/App_Data/NewMCCL.mdb;")

Yours humbly
Phil Hall