Toad World Issues

Toad World Community

NOTE: This forum is for questions and discussions concerning the Toad World website and not for products/platform.
 
Please post product/platform questions in their respective forums.  Thanks!

Community Discussion

pravnis
Follow / 28 Aug 2014 at 5:11am / Toad World
Latest post by on 28 Aug 2014 at 3:10pm

Cross Query Error

Expand content
I am ty to run Cross Query with Oracle and MS SQL paltforms and getting this below mentione error at the time of execution Cross Query Database Error: Invalid data source definition: Data source name not...

I am ty to run Cross Query with Oracle and MS SQL paltforms and getting this below mentione error at the time of execution
 Cross Query Database Error: Invalid data source definition:  Data source name not found and no default driver specified 1 0

14 2 / Create an account to join the discussion.
seganrasan.subramanian
Follow / 22 Aug 2014 at 1:40pm / Toad World

My system is restarting when i do test connection

Expand content
Hi all, I am using Toad for Oracle Xpert 11.6.0.43 (64 bit) on windows 7 machine (64 bit). When i go away for an hour my system will be automatically locked. when i login again, i am getting "Your...

Hi all,

I am using Toad for Oracle Xpert 11.6.0.43 (64 bit) on windows 7 machine (64 bit). When i go away for an hour my system will be automatically locked. when i login again, i am getting "Your PC has awakened from ***, do you want to reconnect?" msg from toad. If I press Yes, my system is restarting. 

if i press No, connect is lost. When I perform 'test connection" again it is restarting. could you please provide a solution to this problem.

thanks in advance.

Segan.

12 0 / Create an account to join the discussion.
shashikant
Follow / 31 Jul 2014 at 3:32pm / Toad World
Latest post by on 1 Aug 2014 at 6:32am

Automated Email from Toad

Expand content
Hi, I have created one automated task using toad utility. I want to send email from that created task. But when I am executing the task it is giving me below error. Error : The handshake failed...

Hi,

I have created one automated task using toad utility.

I want to send email from that created task.

But when I am executing the task it is giving me below error.

Error :  The handshake failed due to an unexpected packet format.

    at Quest.Toad.Workflow.Activities.SendEmailActivity.SendMail(SmtpServer server, MailMessage email)
   at Quest.Toad.Workflow.Activities.SendEmailActivity.Execute(ActivityExecutionContext executionContext)

Can any one explain me why this error occured in toad?

Please help.

 

Thanks,

 

67 2 / Create an account to join the discussion.
mbmannubisht
Follow / 29 Jul 2014 at 2:18pm / Toad World

Generic MySQL Query

Expand content
Hi All, I want to write one query in MySql which gives the complete details of customer. customer field Identity are as follow in main table: cust_id, country, state,city,address,cut_name,cust_emaiaddress...

Hi All,

I want to write one query in MySql which gives the complete details of customer.

customer field Identity are as follow in main table:

cust_id, country, state,city,address,cut_name,cust_emaiaddress,pincode,mobilenumber,rule_name,rule_applied etc etc

Second is the rule table e.g Rule_creator

rule_id,rule_name,rule_applied,rule_createdate,rule_createdby, etc etc

Condition of Rules : All rules are applicable only column

1) if rule is applicable on country column then no rule will apply others column like state,city

2) if rule is apply on state for e.g

      a) N,E,W,S

      b) N,E

         etc etc then no repeat rule is apply others column like city go on

3) if rule is apply on city

       a) N city

      b) South city

etc

Please guide me the best optimized query for this problem

44 0 / Create an account to join the discussion.
CapIsland
Follow / 13 Feb 2014 at 8:12am / Toad World
Latest post by on 6 Jun 2014 at 2:54pm

Creating a New Account

Expand content
I found myself stuck on the change password screen. I had to delete cookies (as unable to log out either) to stop it doing this. Well done for messing up something so basic as registering.

I found myself stuck on the change password screen. I had to delete cookies (as unable to log out either) to stop it doing this. Well done for messing up something so basic as registering.

331 4 / Create an account to join the discussion.