My appln component (VC++ com server) uses ADO to connect to an MS access DB file (access 2000 format). we are using Microsoft.Jet.OLEDB.4.0. now, we are changing the provider to MSDASQL. in doing so, one of the query to read the DB file is failing.
it throws the exception:
COM Error Code: 80040e10 Message: IDispatch error #3088 Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 30.
The same query works perfect with the old provider.
Is this any version/compatibility issue with MSDASQL?
Please help me with your suggestions.