Database Query (OLEDB) Tool
Creating a formula field within the OLEDB query tool fails with error 0x80070582
Last Updated: July 4, 2022Symptom 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, 2022Symptom 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...
