Skip to content
View Categories

Database Query (OLEDB) Tool

2 articles

Creating a formula field within the OLEDB query tool fails with error 0x80070582

Last Updated: July 4, 2022

Symptom When you create a new formula field within the OLEDB query tool you may see the following error: 0x80070582 Cause Caused by having multiple tasks with OLEDB query tool opened and editing the same formula field. Background 0x80070582 is a Windows error code meaning “Class already exists”. In the context of this issue the...

Creating a Global OLEDB Connection – Server name length restriction

Last Updated: July 4, 2022

Symptom When creating a new Database Query (OLEDB) global connection and selecting a server from the drop down list the interface restricts the display of the server name to no more than 20 characters. This can make instances with particularly long names difficult to identify. Solution When creating the connection and within the Available OLEDB...