Problem in passing parameters to SQL OLE DB provider

Yannis Makarounis

Delphi Developer

Tue, 27 Jan 2004 23:37:21 GMT

Problem in passing parameters to SQL OLE DB provider

I have a clientdataset+provider+adoquery with a SQL statement with 3
parameters. I set the parameters and try to open the cds and I get the error
"Multiple-step OLE DB operation generated erros. Check OLE DB status value
if available".
This only happens with SQL Server 2000. The same app works with Access 2000.
Any ideas
Yannis

Other Threads

1. OLE DB Provider for ODBC OR Microsoft Jet 4.0 Ole DB Provider

2. MS OLE DB Providers for ODBC and SQL Server

3. isapi AND ole db sql server provider

4. Problems with Microsoft OLE DB Provider for Oracle

5. Problems with Delphi 5 and Adaptive Server Anywhere 7.0 OLE DB provider

6. Ole db provider problem!!!

7. Problems with OLE DB Provider for ODBC Drivers

8. Microsoft Jet 4.0 OLE Provider vs OLE Provider for ODBC

9. Fail POST record using Provider OLE DB for Visual Foxpro

10. OLE DB Provider for Paradox