Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help me on this error?
I am trying to use Access file, to validate the user credentials.
My configuration is below:
Override connection string : Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\Sample.accdb;Uid=;Pwd=;
Error:
1/1/2015 16:14:16.2018001 | Information | (Database.DatabaseProvider) Connection verified. |
1/1/2015 16:14:16.3863586 | Information | (Database.DatabaseProvider) Dismissed "lower(...)" as the current 'LOWER-CASE' function. |
1/1/2015 16:14:16.3961236 | Information | (Database.DatabaseProvider) Using "lcase(...)" as the current 'LOWER-CASE' function. |
1/1/2015 16:14:16.4801026 | Error | (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.4801026 | Error | (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.4801026 | Error | (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.4810791 | Warning | (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. |