3/15/2018 1:16 PM | |
Joined: 9/19/2009 Last visit: 10/19/2024 Posts: 459 Rating: (85) |
Hi nestor strSQLServer is the server name, but I don´t know. I guess you have install ConnectivityPack Server and ConnectivityPack Client if you are running from the client? If you have installed the ConnectivityPack Server, you can try if it works, because if you open Graphics Designers, you will have a new toolbar button, and you can create a new pdl to test the new provider. Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
3/15/2018 5:29 PM | |
Joined: 9/19/2009 Last visit: 10/19/2024 Posts: 459 Rating: (85) |
Hi nestor
Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
3/19/2018 10:55 AM | |
Joined: 9/19/2009 Last visit: 10/19/2024 Posts: 459 Rating: (85) |
Hi nestor You can´t do that. You must use WinCCOLEDBProvider, because you are using special query like this.
This isn´t standart SQL Server Querys. If you have problem, if you want send me the full script and I will check Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
3/21/2018 11:30 AM | |
Posts: 9 Rating: (0) |
Hi everyone, I feel the delay of my response. The problem with the WinCC OLEDB Provider is solved: everything was related to the system version of the Microsoft Office. I wrote that my Excel belongs to a x32 version, but I had a mistake: it was a x64 program. When I installed a x32 version of Office and executed the macro it worked fine and the error about the provider dissapeared! Now I have a little problem: the macro access without problem to the database, identifies all the tags contained, but when I ask for values it only shows me zeros. I tried using the example from this URL: https://support.industry.siemens.com/cs/ww/en/view/35840700, but it happens the same. Any ideas about this? Thanks a lot beforehand. |
This contribution was helpful to1 thankful Users |
Follow us on