5/22/2019 6:57 AM | |
Joined: 12/9/2010 Last visit: 10/8/2022 Posts: 623 Rating: (77) |
Respected all, I had a WinCC backup in V6.2, OS was Windows 7. I migrated successfully it to V7.4 SP1. This is because customer was interested in Windows 10 OS. (for maintenance purposes). The HMI program is communicating properly but the report (using ODBC) is not showing any data but Data is visible in SQL server. The report system was functional in Window7 from last 5 years. I have attached configuration manual for reference. Attachment001_Report Installation Procedure.doc (131 Downloads) |
Last edited by: Sachinpatke at: 05/22/2019 11:17:36If you like the comment, rate it (right top) or thank it (left bottom). |
|
5/22/2019 12:06 PM | |
Joined: 9/19/2009 Last visit: 9/14/2024 Posts: 459 Rating: (85) |
Hi Did you create the new ODBC , StoreProcedure in your new machine? For testing purpose, you can execute the procedure and you will see if you get any data, ooen SQL Management Studio, and test it. Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
This contribution was helpful to1 thankful Users |
5/22/2019 1:12 PM | |
Joined: 12/9/2010 Last visit: 10/8/2022 Posts: 623 Rating: (77) |
Hi *PHS*, Thanks for reply. 1. New ODBC & store procedure are done. All steps described in manual are done. Except ODBC setting, There are 2 options available- ODBC 32 bit & ODBC 64 bit in Windows 10 PC. Earlier (Windows 7) only one option was available. 2. Store procedure is working fine. Data is available in SQL server in new table. 3. In Excel, the report is also generated but data dump is not happening & all reports are seen blank. The problem is suspected to be between SQL & Excel. WinCC RT License & Excel license are true. Attachment002_Report Configuration Procedure.doc (117 Downloads) |
Last edited by: Sachinpatke at: 05/22/2019 13:14:34If you like the comment, rate it (right top) or thank it (left bottom). |
|
5/22/2019 1:48 PM | |
Joined: 9/19/2009 Last visit: 9/14/2024 Posts: 459 Rating: (85) |
Hi I don´t know where is the problem, but I will try the next: 1.-WinCC = x86 , so create ODBC 32 bit. Test again if works. If not works 2.-Create a new VBSCript and use the ODBC settings to see if you can connect to your database and retrieve data. This will tell you if this settings ODBC is right. Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
Follow us on