Hi,
I`m triying to configure the OleDbPRovider an get the data in Excel 2016 as is shown in the Help, but the provider does not appear in the provider list.
All is running in the same machine. I have WinCCOA 3.10 SP1, the machine is running under Windows 7 64 bits and the version of Excel is 2016.
I have added the ole DB manager, and registered PVSSOleDbExeps.dll (regsvr32 PVSSOleDbExeps.dll). Also i have registered PVSS00oledb.exe ( PVSS00oledb.exe /regserver). I could not find PVSSoledb.dll, so i can´t register it.
What am i missing?
Also, this is a test previous to conigure it in a redundant system. Is there any problem when having redundancy?
Thank you very much
WinCCOA 3.10 SP1 Ole Db Provider configuration
- jonred
- Posts:36
- Joined: Mon Mar 06, 2017 10:24 am
WinCCOA 3.10 SP1 Ole Db Provider configuration
- agruber
- Posts:147
- Joined: Tue Sep 07, 2010 2:52 pm
Re: WinCCOA 3.10 SP1 Ole Db Provider configuration
Hello,
Version 3.10 is really old.
When using Excel 2016 you have probably the issue using a 64bit version of Excel with a 32bit OleDB which probably does not work.
If you modify an older system I suggest to do an upgrade to 3.15 before and use modern techniques like Webservices to get data from WinCC OA. With Excel 2016 this works really great.
BR, Andreas
Customer Care
Version 3.10 is really old.
When using Excel 2016 you have probably the issue using a 64bit version of Excel with a 32bit OleDB which probably does not work.
If you modify an older system I suggest to do an upgrade to 3.15 before and use modern techniques like Webservices to get data from WinCC OA. With Excel 2016 this works really great.
BR, Andreas
Customer Care
- jonred
- Posts:36
- Joined: Mon Mar 06, 2017 10:24 am
Re: WinCCOA 3.10 SP1 Ole Db Provider configuration
Thanks cor the redpons, but the problem is that this is a customer request that has the 3.10 version and has no intention of upgadring in the short term.
I was using excel for testing purposes, but the customer wants to make queries with an app of its own. I inow that this app can get data from accesdb, so oledb provider should be sufficient. What are the key points to configure the provider in 3.10 version?
In any way, if i can get an old 32 bit version of excell should i see the provider?
Thanl you again
I was using excel for testing purposes, but the customer wants to make queries with an app of its own. I inow that this app can get data from accesdb, so oledb provider should be sufficient. What are the key points to configure the provider in 3.10 version?
In any way, if i can get an old 32 bit version of excell should i see the provider?
Thanl you again
- agruber
- Posts:147
- Joined: Tue Sep 07, 2010 2:52 pm
Re: WinCCOA 3.10 SP1 Ole Db Provider configuration
That is unfortunate.
My options with 3.10 are limited. I was able to verify the OleDB driver of 3.15 gets listed in Excel 2016 32bit, see screenshot. You have not told which Excel version you are using right now. But it you are using Excel 64bit, you should try the 32bit version.
If you are unsuccessful with OleDB you could also give the COM manager a try. 3.10.2 is also an option.
For more help in 3.10.1, please get in contact with sales@etm.at .
BR, Andreas
Customer Care
My options with 3.10 are limited. I was able to verify the OleDB driver of 3.15 gets listed in Excel 2016 32bit, see screenshot. You have not told which Excel version you are using right now. But it you are using Excel 64bit, you should try the 32bit version.
If you are unsuccessful with OleDB you could also give the COM manager a try. 3.10.2 is also an option.
For more help in 3.10.1, please get in contact with sales@etm.at .
BR, Andreas
Customer Care
- Attachments
-
- a_labropoulos@akatt.gr
- Posts:25
- Joined: Sun Nov 06, 2016 2:02 pm
Re: WinCCOA 3.10 SP1 Ole Db Provider configuration
Hello!!
Is there any way to read data from specific cells from excel file and then insert the values to a datapoint ??
Is there any way to read data from specific cells from excel file and then insert the values to a datapoint ??
- agruber
- Posts:147
- Joined: Tue Sep 07, 2010 2:52 pm
Re: WinCCOA 3.10 SP1 Ole Db Provider configuration
You could parse an Excel file with the Excel COM objects, in this case you need to implement the access to your Excel file in CTRL.
Maybe the better alternative is to set the value(s) directly from Excel by calling a a webservice, the example here
https://www.gruber.info/2018/03/everybo ... cc-oa.html
can easily be adapted to be able to set values.
Take a look how the dpCreate was done and modify it to your needs.
BR, Andreas
Customer Care
Maybe the better alternative is to set the value(s) directly from Excel by calling a a webservice, the example here
https://www.gruber.info/2018/03/everybo ... cc-oa.html
can easily be adapted to be able to set values.
Take a look how the dpCreate was done and modify it to your needs.
BR, Andreas
Customer Care