Hi, I am at my wits end. I created and worked on a Cross Connection Query yesterday. The Query Joins tables across Three SQL Servers, and Two different Excel Workbooks. All Connections where working yesterday and the query was returning results. I saved and closed for the the day.
This morning I went back to my query to complete it. Now Toad Data Point acts as though it is not a Cross Connection Query, and returns errors that it cannot connect to my data sources. Any attempt to create a new Cross Connection Query are thwarted the system will not allow me to create one, edit one, or run one.
This is extremely frustrating. I have a report project due today and need to get this completed.
What am I missing here?