+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Others (https://www.learnqtp.com/forums/Forum-UFT-QTP-Others)
+--- Thread: Connecting to oracle (/Thread-Connecting-to-oracle)
Connecting to oracle - praveendasika - 08-24-2012
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
RE: Connecting to oracle - ravi.gajul - 08-24-2012
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_Connecthttps://www.learnqtp.com/qtp-database-part2-how-to-create-connection-strings/
Regards,
Ravi