471,322 Members | 1,550 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,322 software developers and data experts.

How to use a Connection String in an Access Data Source

Hello,

I have a Connection String defined in my Web.Config:

<connectionStrings>
<add
name = "dbAccess_JaquelineRoxoAtelier"
connectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data
Source = C:\Documents and Settings\Miguel\My Documents\Visual Studio
2005\WebSites\MyWebSite\App_Data\MyWebSite.mdb; User Id=; Password=;"
providerName="System.Data.OleDb" />
</connectionStrings>

And I have an Access Data Source:

Private Sub adsNews_Init(ByVal sender As Object, ByVal e As
System.EventArgs) Handles adsNews.Init

' Define adsNews properties
With adsNews
.SelectParameters.Add("@Culture",
System.Threading.Thread.CurrentThread.CurrentCultu re.ToString())
.SelectCommand = "web_News_SELECT_Last10"
.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
End With

End Sub

How do I make my Access Data Source to use that connection string?

Thanks,

Miguel

Sep 27 '06 #1
0 1295

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Paul Robinson | last post: by
5 posts views Thread by Alec | last post: by
5 posts views Thread by Dave Dudley | last post: by
16 posts views Thread by peshekeedweller | last post: by
20 posts views Thread by fniles | last post: by
13 posts views Thread by Jennifer.Berube | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.