Error when Tying to connect to Oracle DB

[wheelercha]

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

[Saket]

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.

[wheelercha]

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?

[Saket]

as per the error, I guess your TNS entry is not proper.

[Jackomcnabb]

verify that the server your trying to connect to is in your tnsnames file in the oracle direcotry on the box