Re: [sqr-users] SQR 6.2 with Oracle 10g

[Ray Ontko <rayo@ontko.com>]

Kim, Ian, et al.,

I currently have SQR 6.2 on Solaris using 9i client against a 9i 
database.  I need to upgrade to an Oracle 10g database and want to know 
if I also need to upgrade to the 10g client and a newer version of SQR. 
I assume that my two options are: 1) old sqr with 10g client, or 2) old 
sqr with 9i client (Kim's scenario). I don't mind going to a newer 
version of SQR eventually, but need to know if I have to do it right 
away.  Sounds like Kim was able to get things working using approach #2, 
but not without some difficulty. Ian's situation is a little different 
since he's using an ODBC connection; we're using the Oracle native 
interface version.

Is anyone out there using scenario #1: 10g database, 10g client, 
Solaris, SQR 6.2? Do I need to "relink" sqr 6.2 with the 10g libraries?  
If so, is this painful? Does the resulting SQR program work without 
causing me to introduce changes to my SQR code? We're using SQTs, but 
it's not a problem for us to recompile.

Thanks for your help.

Ray

Kim Prisk wrote:
> Ray/Ian,
>
> Are you folks talking about
>
>   1. using the Oracle 10g client with an earlier database
>   2. using an earlier Oracle client but accessing a 10g database
>   3. both 10g client and db?
>
> We are using sqr6 against a 10g database and a 9i client.
>
> I have had trouble with (and found work-arounds)
>
> union select all - ('string to decimal object conversion errors') - 
> ended up performing each select separately and merging the results 
> into an array
> had to use different names for the same variable if the variable is 
> used more than once to fix 'ORA-01008: not all variables bound' errors
> string to decimal conversion errors - had to use a nvl around some 
> columns that did not require a nvl on an earlier database.
>
> None of the above were a problem with a 9i database.
> Not all of the above applies to all sqr reports we have where there 
> are union selects etc.
> Mostly the reports could be run from sqrw OK, but not as sqrt 
> (compiled) where we got the errors.
> which means they compiled OK
>
> Cheers
> KIM
>
>
> Ian Mills wrote:
>> Ray,
>>
>> We are having trouble using SQR 8.2 against Oracle 10Gr2. SQR 8.3 & 
>> 8.5 should work using the Oracle 10.2 ODBC driver. Hyperion doesn't 
>> support the provided 3rd party connection software using SQR for Oracle.
>>
>> Regards,
>> Ian
>> ORIX Australia Corp Limited
>>
>>
>>  
>>>>> rayo@ontko.com 16/12/2006 8:32 am >>>
>>>>>         
>> Howdy,
>>
>> Does anyone happen to know if SQR 6.2 works with Oracle 10g?  If I 
>> want to use the 10g SQLnet client, do I need to upgrade to a new 
>> version of SQR? 8.3? 9.0?
>>
>> Ray
>
> _______________________________________________
> 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