cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

nav
Occasional Contributor

Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

Hi all how can we can connect to oracle SQL Developer using test complete keyword frame work. 

9 REPLIES 9
Community Hero

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

In what context?  Are you intending to use the data in a data driven loop?  ARe you creating a table variable based upon a DB query?  Are you doing a DB checkpoint?

What have you tried?  What errors are you getting?


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
nav
Occasional Contributor

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

Currently in manual sceanrio, We Take count of Tables using Oracle SQL developer and validate them. So my scenario here is to automate this process.

I have few queries which i need to run from test complete connecting to oracle Sql developer and get those count  of tables.

So i guess i need to connect to DB for validating the count.

Community Hero

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

There are multiple ways to connect to databases as outlined here: https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sou...

 

Is there a specific issue you have connecting?


Thanks,
Carson

Click the Accept as Solution button if my answer has helped
Community Manager

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

Hi @nav,

Did you find the answer to your question? Please share the solution with us.

---------
Tanya Gorbunova
SmartBear Community Manager

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

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

No, Im still facing an issue and trying to get a solution

Community Manager

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

Sad to hear this, @nav.

 

Could you please point out the step where you got stuck?

 

As far as I understand, you will need to create a data-driven test. Carson already mentioned the tutorial. I suggest that you go through it to learn how to implement your task:

https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/tutorials/keyword/index.htm...

---------
Tanya Gorbunova
SmartBear Community Manager

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓
Community Hero

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework


@nav wrote:

No, Im still facing an issue and trying to get a solution


What "issue"?  Are you getting an error message? Is there a behavior you're expecting but it's not happening?  Is @cunderw correct that you're doing a data driven loop?  Or are you intending to do a query and validate the results? 

Depending on the specifics of your situation, different solutions are needed.  The more details you can give as to what you're attempting, the better.  It would be helpful if you can include screenshots and code of what you've attempted.

Note that, if you're not doing a DB Checkpoint or a Data Driven Loop, a direct SQL query against a database to bring back a set of results is easier to do using ADO objects and Script code.  This code CAN be called from within a Keyword test, but the function should be written in the script editor.


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
Highlighted
nav
Occasional Contributor

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

Hi,

I am trying to connect to oracle DB,

1. I have installed oracle ODBC drivers Version 12.1.0.2.0 - (Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications) and (Instant Client Package - ODBC: Additional libraries for enabling ODBC applications). And extracted them to one folder and installed as a admin.

 

2. I also created a tnsname.ora file with following info:

m****** =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ********************** )(PORT = 1520))
)
(CONNECT_DATA =
(SID = m******)
)
)

 

3. And also added a TNS_ADMIN in sytem variables and gave the oracle instant client files extracted folder location path

 

4. And went to path in system variables and added the same racle instant client files extracted folder location path

 

5. When i run ODBC Data sources(64 bit) and click add under User Dsn i get the below error.

 

I am not where is the mistake.

 

DBerror.png

Community Hero

Re: Unable to connect to my localhost DB (MySQL Data base) Using test complete keyword framework

Is that error coming from TestComplete?  It doesn't appear to be a TC error window so it seems that your problem is before you even get to creating the TestComplete connection.


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
New Here?
Join us and watch the welcome video:
Watch the new interview