Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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