+- 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: Error when Tying to connect to Oracle DB (/Thread-Error-when-Tying-to-connect-to-Oracle-DB)
Error when Tying to connect to Oracle DB - wheelercha - 03-19-2010
I am trying to create a connection to an oracle database using a new Data Source. Qtp asks me for a name to give it then a driver. I choose Microsoft odbc for Oracle. Put in a service and password. It acts liek it wants to connect then I get an Error message - 'Out of Memeory' Has anyone seen this before?
Thanks - Charles
RE: Error when Tying to connect to Oracle DB - Saket - 03-19-2010
I have seen this before, which was rectified by the oracle expert (not me
so I dont have the exact solution)what i know is its due to the integration of Oracle Application Server with B2B stops responding, which can be resolved by increasing the heap size ( If I remember it correctly). ask your Oracle expert. or google it you will definitely get a solution there.
else If I find anything, will keep you posted.
RE: Error when Tying to connect to Oracle DB - wheelercha - 03-20-2010
Okay I think the error was due to me. But I was able to create a new DNS connection to the Database. Tested it and it worked.
Problem - now that I am in QTP and doing an Insert>>Checkpoint>>DB and choose my Database, key in password. I get an error: ORA-12154:TNS:could not resolve service name
Driver's SQLSetConnectAttr failed
Any idea about this one Saket?
RE: Error when Tying to connect to Oracle DB - Saket - 03-22-2010
as per the error, I guess your TNS entry is not proper.
RE: Error when Tying to connect to Oracle DB - Jackomcnabb - 03-28-2010
verify that the server your trying to connect to is in your tnsnames file in the oracle direcotry on the box