[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Error while executing


Toad uses SQLNet but uses a different tnsnames file than SQRW (by default).  
Toad uses the tnsnames file on your local machine and SQRW probably will use a 
networked orahome.  Make sure both tnsnames files contain the same stuff and 
you will be fine.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: Steve Cavill [mailto:steve.cavill@infoclarity.com.au]
Sent: Wednesday, July 02, 2003 2:26 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Error while executing


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

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