New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Getting ODBC error while executing the sql query in excel(DB)

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Getting ODBC error while executing the sql query in excel(DB)
Shkumari Offline
Junior Member
**
Posts: 7
Threads: 2
Joined: May 2013
Reputation: 0
#1
Not Solved 05-04-2013, 11:08 PM (This post was last modified: 05-05-2013, 01:49 PM by Shkumari.)
Hi All,

I am new to this forum and even in Automation field also.Actually my problem is: In my application i am doing export to excel and then considering the excel as db and running the sql statment like below:
select disctint(count empid) from <filename>
but getting error as ODBC

But when i am execting select * from <filename> where empid=10 then it is getting executed.
-2147418113 catastrophic failue error getting Sad
i am not sure what is issue.So could you please suggest any tips for this
Find
Reply


Messages In This Thread
Getting ODBC error while executing the sql query in excel(DB) - by Shkumari - 05-04-2013, 11:08 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  error when executing an UFT automation script alexalloza 0 1,546 10-30-2018, 06:17 PM
Last Post: alexalloza
  Executing via create "RES"xx folder? nishitd 0 1,253 03-07-2018, 01:09 AM
Last Post: nishitd
  QTP-Re-executing script after completion of all iterations JwalantBhatt0602 1 2,696 03-24-2016, 12:37 AM
Last Post: JwalantBhatt0602
  Exe invoked through UFT is unable to access IIS and SQL Server service bkdevise 0 2,155 08-25-2015, 05:49 PM
Last Post: bkdevise
  QTP is getting closed after executing first test in MTM(Batch) Shyama 0 2,153 10-07-2014, 07:26 PM
Last Post: Shyama

Forum Jump:


Users browsing this thread: 1 Guest(s)