Re: [sqr-users] (SQR 5528) ORACLE OCIServerAttach error 12154incursor 0: but TN

["Elvis Pressly" <elvisdman@hotmail.com>]

Use ODBC. Make sure you have the oracle odbc driver. I happen to be working 
yesterday on graphics printing and my main database is oracle. I can also 
connect to other databases(at the same time) as long as they are properly 
setup in ODBC.


>From: "Paul Delange" <Paul.Delange@cami.ca>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>CC: "This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions." 
><sqr-users@sqrug.org>,sqr-users-bounces+paul.delange=cami.ca@sqrug.org
>Subject: Re: [sqr-users] (SQR 5528) ORACLE OCIServerAttach error 
>12154in        cursor 0: but TNSNAMES.ORA is correct!
>Date: Tue, 24 Jan 2006 10:17:36 -0500
>
>
>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



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