Jeannot Diderrich
Top achievements
Rank 1
Rank 1
Jeannot Diderrich
asked on 24 Apr 2010, 09:14 PM
Hello,
I try to connect with a SqlDatSource to a Acces 2003 query with parameters. I get the following error message
Retrieving procedure parameter information is not supported by the 'Microsoft.Jet.Oledb4.0' provider
Does the SqlDataSource not support Acces queries?
Here's the code
Dim report1 As New ReportName()
report1.ReportParameters.Add("NumeroPersonne", ReportParameterType.Integer, 4)
Dim sqlDataSource2 As New SqlDataSource()
sqlDataSource2.ProviderName = "System.Data.OleDb"
sqlDataSource2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Erisk\RiskAssessment\data\RiskAssessment.mdb"
sqlDataSource2.SelectCommand = "std_KYC_BO_NoParam"
sqlDataSource2.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
sqlDataSource2.Parameters.Add("@NumeroPersonne", DbType.Int32, "=Parameters.NumeroPersonne")
report1.DataSource = sqlDataSource2
rvClients.Report = report1
rvClients.RefreshReport()
I try to connect with a SqlDatSource to a Acces 2003 query with parameters. I get the following error message
Retrieving procedure parameter information is not supported by the 'Microsoft.Jet.Oledb4.0' provider
Does the SqlDataSource not support Acces queries?
Here's the code
Dim report1 As New ReportName()
report1.ReportParameters.Add("NumeroPersonne", ReportParameterType.Integer, 4)
Dim sqlDataSource2 As New SqlDataSource()
sqlDataSource2.ProviderName = "System.Data.OleDb"
sqlDataSource2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Erisk\RiskAssessment\data\RiskAssessment.mdb"
sqlDataSource2.SelectCommand = "std_KYC_BO_NoParam"
sqlDataSource2.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
sqlDataSource2.Parameters.Add("@NumeroPersonne", DbType.Int32, "=Parameters.NumeroPersonne")
report1.DataSource = sqlDataSource2
rvClients.Report = report1
rvClients.RefreshReport()
1 Answer, 1 is accepted
0
Hello Jeannot Diderrich,
You can connect to a Microsoft Access database using the Telerik SqlDataSource.
Unfortunately we don't support parametrized Access Queries (stored procedures) because the provider can't retrieve the procedures' parameter information. Currently we recommend using of text queries to retrieve data from Access.
Have in mind when you are working with an OLE DB database, parameters in a parametrized statement are not named and instead are specified with the placeholder character '?'.
Greetings,
Peter
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
You can connect to a Microsoft Access database using the Telerik SqlDataSource.
Unfortunately we don't support parametrized Access Queries (stored procedures) because the provider can't retrieve the procedures' parameter information. Currently we recommend using of text queries to retrieve data from Access.
Have in mind when you are working with an OLE DB database, parameters in a parametrized statement are not named and instead are specified with the placeholder character '?'.
Greetings,
Peter
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.