Connecting to oracle

[praveendasika]

Hi ,

I have a machine with windows Application isntalled.This application connects to an oracle database in a huge server.I got hold of the connection string of the application.

The problem is when I try to use QTP to connect to database from the client machine , Its failing to identify the provider.

The question is can we connect to the database using qtp as the db is not local .if so,What method can I use to connect ?

the application can connect to oracle.What should i do to make qtp script connect to the db ?do i need to open any ports ,firewall,increase connections in oracle pool ? I know sql server but not oracle unfortunately

[ravi.gajul]

Create a DSN if you are aware of the server details and use DSN instead of connection string
you will have to use the below lines for establishing connection

Code:

Str_Connect= "DSN=<DSNName>;UID=<useridtonconnect to databas>;pwd=<password>;"
'Create Connection object
Set oCon=CreateObject("ADODB.Connection")
oCon.Open Str_Connect

To check on how to create a DSN (Data source name) file or create connection strings please see the below thread
https://www.learnqtp.com/qtp-database-pa...n-strings/


Regards,
Ravi