Re: [sqr-users] (SQR 5528) ORACLE OCIServerAttach error 12154 incursor 0: but TNSNAMES.ORA is correct!

["kyle.leonard" <kyle.leonard@1answersolutions.com>]

Search and find your SQR.ini file.  Verify the [Environment: Oracle] section
is pointing to the SQR directory on your machine. I've seen where this is
pointed to a server and SQR runs the report on a server somewhere, using the
databases defined there.

If you aren't already, try running it with SQRW.exe (Windows environment)
instead of the Developer.

Kyle Leonard
1Answer Solutions

On Tue, 24 Jan 2006 09:35:57 -0500, Paul Delange wrote
> Hi All,
> 
> I'm trying to run an SQR off our db server for speed reasons & get 
> 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.
> 
> There is only one TNSNAMES.ORA file on this box & it does contain the
> database in question. I suppose it's concievable that SQR is somehow
> finding a TNSNAMES file on the network (somewhere) that is not uptodate.
> 
> I can login the the database on the same machine with SQLPlus no problem.
> 
> Can anyone shed some light on this? Is there a setting I can make 
> that will SQR look on the local drive for tnsnames.ora?
> 
> Thanks, Paul
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users



___________________________________
Kyle J. Leonard
kyle.leonard@1answersolutions.com

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