I have a DB in production on SQL Server 2005. I backup it and restore on my PC to works.
I made changes and test it on my PC, before apply to DB of production.
The DB's are identical.
These DB's are on different server, with different connection in TOAD SS.
3 weeks ago I wrote views in my TOAD 6.0 beta on DB of production. All is OK.
I can use these views without problems in Edit SQL, but yesterday I try to use these views in SQL Query Builder and I have one problem.
See my screensoht TOAD_VIEW.JPG in attach.
In details, I try to drag and drop a view in SQL Query Builder, but view was created on DB of production on another server and your message advise me of the problem.
Attention, it's a false problem, because I can select columns of view and press F9 to see results.
For details see my screenshots TOAD_EDIT.JPG and TOAD_RESULTS.JPG.
Why don't you think to add possibility in TOAD VIEWS window to change the parameter -original connection - manually ?
I try to edit view with menu - EDIT TOAD VIEW - to change orignal connection but I obtain an error message.
See my screenshot TOAD_ERROR.JPG in attach for details. TOAD can find original server of the connection. Correctly because the server of DB is on another network.
TOAD works OK, but I want change original connection parameter of my views to works correctly with the same views in all case, production and development on two different servers/PC's.
I stay tune for your consideration.