468,736 Members | 2,093 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,736 developers. It's quick & easy.

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 1247

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
By using this site, you agree to our Privacy Policy and Terms of Use.