Forum Discussion
Solved
DataSource.Error : OLE DB : Multiple-step OLE DB operation generated errors.
Hi, This message appears when I try to refresh data in table: DataSource.Error : OLE DB : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No wor...
Hi Adrien,
For this error, following are two possible causes of this error:
- In the registry, under the key for an OLE DB provider's CLSID, there may be an entry named OLEDB_SERVICES. If the OLE DB provider that is used to make the ADO connection does not have the OLEDB_SERVICES entry, and ADO tries to set up a property that is not supported by the provider, the error occurs. For more information about this registry entry, see the "Resolution" section.
- If OLEDB_SERVICES entry exists but there is a problem in the ADO connection string, the error occurs.
Please refer to the link below to see the details.
Regards,
Charlie Liao
Hi Adrien,
For this error, following are two possible causes of this error:
- In the registry, under the key for an OLE DB provider's CLSID, there may be an entry named OLEDB_SERVICES. If the OLE DB provider that is used to make the ADO connection does not have the OLEDB_SERVICES entry, and ADO tries to set up a property that is not supported by the provider, the error occurs. For more information about this registry entry, see the "Resolution" section.
- If OLEDB_SERVICES entry exists but there is a problem in the ADO connection string, the error occurs.
Please refer to the link below to see the details.
Regards,
Charlie Liao
Hi Charlie,
The OLE DB provider I use to make the ADO connection dont' have the OLEDB_SERVICES entry...
I have added the OLEDB_SERVICES registry entry and it works.
Thank you for your answer.
Regards,
Adrien LEFEVRE