Ask a Question

Oracle connection

Occasional Contributor

Oracle connection

Hey everyone!

I've been surfing either the internet and some TC7 books but somehow nobody has ever written something about this feature.

How can i connect to an Oracle database in order to retrieve data to be compared in my TC script?

I'm currently working on a Script that tests functionality inside my app but i really need to get some data from the DB and compare it. Everything is cool except for the oracle connection. Is there any way to do this without having to set a dsn?

Windows gets really buggy when comes to work with Oracle ODBC anyway... if there's any hint it certainly would be appreciated.

Here's an example of what i'm trying to achieve :

DDT.ADODriver("Driver={Microsoft ODBC for Oracle};Server=;Uid=jmc;Pwd=secure;");

Notice the extreme complexity of my password.!

Best regards and thx in advance.

Community Hero

Hi Carlos,

Have a look at (, hope it will help...
  /Alex [Community Hero]
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.

Hello Carlos,

Try to use the following connection strings within the DDT.ADODriver method call:

DDT.ADODriver("Driver=Microsoft ODBC for Oracle;Server=;Uid=jmc;Pwd=secure;", "TABLE");

// or

DDT.ADODriver("Provider=MSDAORA.1;Password=secure;User ID=jmc;Data Source=;Persist Security Info=True", "TABLE");

Note that the method requires a table name as its second parameter. Please see the DDT.ADODriver article on our Support Portal for details.

Does this help?

Best regards,

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Occasional Contributor

Occasional Contributor

Yes indeed!

Thank you so much i'll try these methods out. Hopefully everything is
going to be fine. One of the main reasons was the fact that i could not
successfully set up a ODBC with either Oracle or Windows Drivers. I do
not know why. Fortunately i found a driver made by "Progress" which
allowed me to connect with "DataDirect Oracle Wire protocol". Connection
successfully Tested made me realize that the only further step would be
to find the Right connection String.

Gonna try this and let you guys know.

Thank you so much for this it really helps...seriously guys both of you!

Best Regards,

Occasional Contributor

No luck...

The first one throws an exception that says : DataSource name not found and no Default driver specified

Any hint?.. How comes there is no example available to test this.... TestComplete examples only show demos with CSV driver :S!!

Well i'll keep trying!

Thanks again!
Occasional Contributor

Hey Guys,

We finally made it! After hours and almost days of working on this stuff!! (just kidding)

Is there any test developer position on Automated Qa?? kidding again!


First we needed to download the driver. For some crazy reason we could not made this with Oracle nor Miscrosoft drivers. We had to download Progress DataDirect ODBC driver. Really cool!

After reading loads of websites (I was actually wondering why Test Complete does not come with a nice Oracle connection example) we finally came up with the simpliest and most useful connection query... here's the example and once again thank you so much guys for your help.

Cheers !


Example :

function connect(){

  var connectstring = "Data Source=dsnOracle;User ID=user;Password=password"; //3 params only!!!

  var patientlist = ADO["CreateADOQuery"]();

  patientlist["ConnectionString"] = connectstring;

  patientlist["SQL"] = "Select pat_lastname FROM pat_data";



  res = patientlist["FieldByName"]("pat_lastname")["Value"];



Hi, i am facing an exception "[Microsoft][ODBS Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" with the following script

Sub TestProc

  Set oraConnection = ADO.CreateADOConnection

  oraConnection.ConnectionString = _

  "Driver = Oracle in Home1; Data Source=JANUSDRIVER; User Id=userID;Password=userPassword;" 

  'Also used the following string

  ' "Data Source=JANUSDRIVER; User Id=userID;Password=userPassword;" 

  ' Suppress the login dialog box

  'oraConnection.LoginPrompt = False



End Sub

i have also used DDT.ADOConnection but facing the same problem

Muhammad Mazhar Mahmood
Certified Software Tester (CSTE)

Hi somehow i am able to create a oracle conection but now i am facing problem while executing query

Sub TestProc

  Set AConnection = CreateObject("ADODB.Connection")

  AConnection.ConnectionString = _

  "Provider=MSDAORA.1; User Id=user;Password=pasword;Data Source=INTRA"


  query =  "Select * from prj_project Where PRJProJECTID_NB = 7301"

  Set RecSet = Aconnection.Execute(query)


  While Not RecSet.EOF

    Log.Message "Hello"




End Sub

Prompts me Data Type not supported.

Muhammad Mazhar Mahmood
Certified Software Tester (CSTE)

Hello Muhammad,

Please make sure that you have specified your query correctly in the Execute method.

Dmitry Nikolaev

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Showing results for 
Search instead for 
Did you mean: