RE: Automation Designer question

I was in the process of typing a response when this message was delivered. Glad you got it working. We'll consider your suggestion. Thanks!

From: [email protected] [mailto:[email protected]] On Behalf Of John Graves
Sent: Monday, January 16, 2012 1:13 PM
To: [email protected]
Subject: RE: [toad] Automation Designer question



Oh, I should add that if I go to the first action in the app, an
export dataset action, and choose Properties, I I see where I can
alter the filename, i get an ORA-01017 invalid username/password;
login denied error, which makes sense as I changed the password to the
old production server. After acknowledging that error, I see where I
can choose the export format. Excel is already chosen and I have the
customary two tabs, Options and Dataset. I even see the connection
icon on the upper left and it's set to the proper, new production DB,
but that choice hasn't stuck. I'm going to try once more. Perhaps,
seeing the correct connection, I didn't hit Apply last time.

That seems to have fixed it. I must have failed to hit Apply before.
To be fair, I may not have realized it was needed. It showed the
correct connection already, as that is the only DB connection I had
then or have at the moment. It didn't occur to me to hit Apply, even
though the correct connection was already chosen, to make the change
permanent.

Maybe an indication of the current connection default for an action
could be placed on that screen? It would have saved me the problem of
this issue I think. There's a lot of empty real estate there. Just a
thought :)

John

-----Original Message-----
From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of
John Graves 1ep2dq602-at-sneakemail.com
|TOAD_Group/AllowMedSolandEvolved|
Sent: Monday, January 16, 2012 11:37 AM
To: John Graves; [email protected]<mailto:toad%40yahoogroups.com>
Subject: RE: [toad] Automation Designer question

Matt,

That was my thought originally, but I simply cannot find where to do
that. If I right click on the app and choose Properties, I get an App
Properties box which allows me to rename the app, but nothing else.
I'm running Toad 11.0.0.116. How does one get to a place where the
properties can be edited?

Roger,

Thanks. I had thought of renaming the alias in the TNS file. That
would certainly work, and I'll do that if need be, but I am hoping to
learn something and do this in a better way if I can. Thanks for the
suggestion.

John

From: [email protected]<mailto:toad%40yahoogroups.com> On Behalf Of Matt Wilkins
Sent: Monday, January 16, 2012 11:11 AM
To: John Graves; [email protected]<mailto:toad%40yahoogroups.com>
Subject: RE: [toad] Automation Designer question

If I'm understanding you correctly, you simply need to modify the
properties of all actions within your app to point to the correct
server.

From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of
John Graves
Sent: Monday, January 16, 2012 11:57 AM
To: [email protected]<mailto:toad%40yahoogroups.com>
Subject: [toad] Automation Designer question

I have some apps that have been happily running for over a year now
against our production DB. Last week I had to migrate our production
DB to a new server. I've searched, but I cannot figure out how to have
the apps hit the new production server, by default, as opposed to the
old one.

I know I can run these against the new server using Run with
connections, choosing the correct server, and it will hit the one I
want, but how do I change the server that the apps will hit if I just
choose Run? I f someone can tell me, or at least point to a source
where I can find the answer, I'd appreciate it.

John