Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the 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
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
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