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

["Paul Delange" <Paul.Delange@cami.ca>]

Kyle, et al,

The Oracle section of SQR.ini shows only a date format - is there something
else I should add?

I am already running thru SQRW (peoplesoft installation).

Thanks, and, any other idea's?

Thanks, Paul



|---------+------------------------------------------------>
|         |           "kyle.leonard"                       |
|         |           <kyle.leonard@1answersolutions.com>  |
|         |           Sent by:                             |
|         |           sqr-users-bounces+paul.delange=cami.c|
|         |           a@sqrug.org                          |
|         |                                                |
|         |                                                |
|         |           01/24/2006 09:57 AM                  |
|         |           Please respond to "This list is for  |
|         |           discussion about the SQR database    |
|         |           reporting       language from        |
|         |           Hyperion Solutions."                 |
|         |                                                |
|---------+------------------------------------------------>
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |       To:       "This list is for discussion about the SQR database 
reporting language  from |
  |        Hyperion Solutions." <sqr-users@sqrug.org>, sqr-users@sqrug.org      
                 |
  |       cc:                                                                   
                 |
  |       Subject:  Re: [sqr-users] (SQR 5528) ORACLE OCIServerAttach error 
12154 in  cursor 0:  |
  |        but TNSNAMES.ORA is correct!                                         
                 |
  
>----------------------------------------------------------------------------------------------|




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







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