parameter information is not supported by the 'Microsoft.Jet.OLEDB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Im getting this error

Retrieving procedure parameter information is not supported by the
'Microsoft.Jet.OLEDB.4.0' provider

Im using the DeriveParameter method of the OleDbCommandBuilder.

Im trying to execute the "Employee Sales by Country" procedure in the
Northwind database.

What could i do to solve this error?... The command object is well created,
and connection too.
 
Hi,

R u talking about the Northwind that comes with SQL server?
If so why r u using OLEDB instead of SQLserver provider?

if not post the code in question
 
If you are using Jet to connect to an Access database, then yes, it does not
support "Stored procedure parameters". Sql Server, yes.

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataAdapter.Update method problem. 5
Retrieving procedure parameter information is not supported 1
Run Access Query From Excel With Parameter? 3
About the DataGridView event Validating 1
Concurrency Nightmare 3
How can an output parameter update a DataTable in a DataSet 0
Deleting MDB after creating it, causes "file is in use by another process" 3
Pass optional parameters to a method in a Dictionary (C#2.0) ? 10

Back
Top