S
shapper
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.CurrentCulture.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
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.CurrentCulture.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