Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.
0 Replies