Ask a Question

Test Complete Connection with database

Occasional Contributor

Test Complete Connection with database

I have been trying to connect to the Oracle SQL developer using TestComplete (version 15).

The following is the connection string that I am trying to use to connect to Oracle. For database connection, I use the following and gets connected:

Host: hostName , Sid: sidname, Port: portNuber, UserName: userName, Password: password

But I am not able to connect via TestComplete.  I have done some research and found the following example to run a store procedure, but not able to connect. 

function CreatingStoredProcedure()
var SProc;
  SProc = ADO.CreateADOStoredProc();
  SProc.ConnectionString = "Provider=SQLNCLI;Server=SERVER_NAME;" +
                 "Database=DATABASE_NAME;Uid=USER_NAME; Pwd=PASSWORD;";
  SProc.ProcedureName = "dbo.SelectFromTable";
    // Adding a return parameter


If I use the CONNECTION STRING in that format, I got "Provider not found message". I am not sure what would be my PROVIDER name (I'm a new user of Testcomplete). 


Can someone please help me to solve this problem?  What value should be given to the "Provider"?  Where is the Provider located?


It would be appreciated if you give connection string format and an example with it.  Thank you in advance.




Check out this link. You may get an idea on how to work with databases.
Occasional Contributor

Hi Abishek,


Thank you for your reply.


I have read this link before I post this, but no luck to get connected. I would really appreciate If someone can help me by giving example (step by step would be more helpful). 

Showing results for 
Search instead for 
Did you mean: