The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as Facility Hero) app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
Goals and Symptoms
User gets an error message as shown below when clicking the Show Table button in the waveform window.
Microsoft OLE DB Provider for SQL Server (0x80040C8E)
Error with provideHTML. Error with GenerateHTML.
WebReachHistoricalASP in GetQuery: -2147218290 Cannot execute default connection: An error occurred in Execute:
PML is not a recognized ODBC vender clause option.
/ion/Historical/GetLogs.asp, line 46
Facts and Changes
Show Table button
Page cannot be displayed
Causes and Fixes
The user follows the sequence of steps below and gets an error:
Another cause of the error is that a * is used for the columns in a Data Log Viewer query in Enterprise 5.6. Vista is able to return the query properly, but Webreach will display the above error.
If the problem is due to the Selected Columns field in the Query, then simply remove the * and replace it with each individual column.
When viewing the table of waveforms, check the checkbox next to the waveform icon before proceeding to view the graph.
This has been observed on ION Enterprise 5.5 SP2 with the IE7.0 hotfix, Internet Explorer 7.0 and 6.0.
Last Revised: 6-Sep-07
All content © 1992-2007 Schneider Electric
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!