Oracle 10g to 11g upgrade and QTP 11 connection issue

This might be better posted to Microsoft forum, but since I'm here...

I had a connection string that worked on a 10g Oracle DB when using the HP QTP tool. Now the string doesn't work. I keep getting

"[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not
resolve the connect identifier specified"

The changes of course were server name, db name, username, pwd.

Since the DBA could not find anything different between the 10g and 11g DBs or servers she asked me to try the Oracle Driver.

So we did with this connection string:

strDatabaseConnectionString = "Driver={Oracle in OraClient11g_home1}; Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=servername)(PORT=3028))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=dbname))); uid=myuid;pwd=mypwd;"

Now we are getting this error:

[Microsoft][ODBC Driver Manager] Data source name too long

Please Help

0 answers