ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   owc next version must support datasets (https://www.excelbanter.com/excel-programming/324911-owc-next-version-must-support-datasets.html)

Sarfraz Ahmed[_2_]

owc next version must support datasets
 
what i have discovered is that owc9 dont support recordsets while owc11
support recordsets

' owc9
objPivotTable.DataSource =objRS

'this give error : Class does not support Automation or does not support
expected interface
But above line of code works fine if owc11 is used.

it means OWC11 is capable of accepting Recordsets as datasource whil owc9 is
not.

while following code doesnt work for any of owc9 and owc11


objPivotTable.DataSource =objDataSet '' doesnt work for b


so i think next version of owc can be made capable of accepeting Datasets as
datasource as well.

Tom Ogilvy

owc next version must support datasets
 
Send requests to:



--
Regards,
Tom Ogilvy


"Sarfraz Ahmed" wrote in message
...
what i have discovered is that owc9 dont support recordsets while owc11
support recordsets

' owc9
objPivotTable.DataSource =objRS

'this give error : Class does not support Automation or does not support
expected interface
But above line of code works fine if owc11 is used.

it means OWC11 is capable of accepting Recordsets as datasource whil owc9

is
not.

while following code doesnt work for any of owc9 and owc11


objPivotTable.DataSource =objDataSet '' doesnt work for b


so i think next version of owc can be made capable of accepeting Datasets

as
datasource as well.





All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com