0 Replies Latest reply: Jan 1, 2015 9:46 AM by Ramkumar Sundaresan RSS

    Error in configurable ODBC while using Access

      Can anyone help me on this error?

      I am trying to use Access file, to validate the user credentials.

       

      My  configuration is below:

       

      Capture.PNG

      Override connection string : Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\Sample.accdb;Uid=;Pwd=;

       

       

      Error:

       

      1/1/2015 16:14:16.2018001Information(Database.DatabaseProvider) Connection verified.
      1/1/2015 16:14:16.3863586Information(Database.DatabaseProvider) Dismissed "lower(...)" as the current 'LOWER-CASE' function.
      1/1/2015 16:14:16.3961236Information(Database.DatabaseProvider) Using "lcase(...)" as the current 'LOWER-CASE' function.
      1/1/2015 16:14:16.4801026Error(Database.DatabaseProvider) DB-search wasn't successful:

      System.Data.Odbc.OdbcException (0x80131937): ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. ||    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) ||    at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) ||    at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) ||    at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) ||    at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) ||    at Database.DatabaseProvider.DoSearch(String[] pattern, eSearchType[] searchTypes, String otherAttribute)

      1/1/2015 16:14:16.4801026Error(Database.DatabaseProvider) Error when trying to make an initial test-search: || ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
      1/1/2015 16:14:16.4801026Error(DSC.DirectoryFramework) setup path not successful for user '' at 'ODBC://localhost': Database.DscException: Error when trying to make an initial test-search: || ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. ---> System.Data.Odbc.OdbcException: ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. ||    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) ||    at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) ||    at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) ||    at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) ||    at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) ||    at Database.DatabaseProvider.DoSearch(String[] pattern, eSearchType[] searchTypes, String otherAttribute) ||    at Database.DatabaseProvider.TestSearchType(eSearchType searchType) ||    --- End of inner exception stack trace --- ||    at Database.DatabaseProvider.TestSearchType(eSearchType searchType) ||    at Database.DatabaseProvider.OpenConnAndGetDomain(String path, String username, String password) ||    at Database.AbstractDSP.SetupPath(String _path, String _username, String _password) ||    at DSC.DirectoryFramework.SetupResource(Guid id, String type, String path, String username, String password, IDictionary`2 newSettings)
      1/1/2015 16:14:16.4810791Warning(DSC.DirectoryFramework) Setting up odbcDSP 'ODBC://localhost' wasn't successful: Error when trying to make an initial test-search: || ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.