Lets Have a fun with Technology.

BTemplates.com

Follow by Email

Thursday, September 25, 2008

System.Data.OleDb.OleDbDataAdapter internal error: invalid parameter accessor: 1 BADBINDINFO.


Problem :-  base    {"System.Data.OleDb.OleDbDataAdapter internal error: invalid parameter accessor: 1 BADBINDINFO."}    System.SystemException {System.InvalidOperationException}

Description And Solution :-

While Using Store Procedure in Access (With .Net) if you Are try to Used Output Parameter
                 like

       
       OleDbCommand sqlCmd = new OleDbCommand();
       AddParamToSQLCmd(sqlCmd, "@ReturnValue", OleDbType.Integer, 0,        
       ParameterDirection.ReturnValue, null);
       SetCommandType(sqlCmd, CommandType.StoredProcedure, SP_USER_MigrantEmployeeID);
   

               Then System Throw Exception like  "+        base    {"System.Data.OleDb.OleDbDataAdapter internal error: invalid parameter accessor: 1 BADBINDINFO."}    System.SystemException {System.InvalidOperationException}" 

                 While Googling and My Personal R & D i Come on Point that You can not Used Output Paramter in MS Acess  While it's Not a Problem With SQL Server.
             
.
Prev Post                                                      All Post                                                           Next Post

0 comments:

Post a Comment