Retrieving procedure parameter information is not supported

  • Thread starter Thread starter HungTrinh
  • Start date Start date
H

HungTrinh

Hi All,

I get an error when I use OleDbCommandBuilder.DeriveParameters to
retrieve procedure parameter information. The error is " Retrieving
procedure parameter information is not supported by the
'Microsoft.Jet.OLEDB.4.0' provider". Below is the query in MSAccess:

INSERT INTO TT_Users ( UserName, [Password], DisplayName, RoleID )
VALUES ([@UserName], [@Password], [@DisplayName], [@RoleID]);

Could you tell how to solve this problem?

Thanks,
Hung
 
Use the ? with Access as parameter placeholders instead of named
parameters as you have here. There's an example in the Help topic
ms-help://MS.VSCC.2003/MS.MSDNQTR.2004APR.1033/cpref/html/frlrfSystemDataOleDbOleDbParameterCollectionClassAddTopic2.htm.

--Mary
 
Back
Top