RE: [sqr-users] Error while executing

[Steve Cavill <steve.cavill@infoclarity.com.au>]

Report builder uses ODBC, whereas SQRW uses OCI so that could explain why
one works and the other does not.  I'm not sure how toad connects.  Can you
connect using the same connect string (host name) with SQL*plus?  Can you
also try tnsping?
Steve.

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Umesh R. Neeli
Sent: Wednesday, 2 July 2003 3:19 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Error while executing


Hi,
   I am trying to execute a simple SQR program suing sqrw. While executing
it gives me the following error

(SQR 5528) ORACLE OCIServerAttach error 12154 in cursor 0:
   ORA-12154: TNS:could not resolve service name
(SQR 4701) Cannot logon to the database.

SQR: Program Aborting.


I am able to access the database through Toad. Through report builder I am
able to connect to the database and create the report but while executing
from Report Builder again it gives me the same error. The database entry
does exist in the tnsnames.ora file. Please let me know how to solve this.

Thanking you,

Regards,
Umesh R. Neeli

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users