Error in configurable ODBC while using Access

Mon, 26 Jan 2026 18:19:17 GMT

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.

topic Error in configurable ODBC while using Access in QlikView

Error in configurable ODBC while using Access