Link to home
Create AccountLog in
Avatar of Julia T
Julia T

asked on

manager

We are using a 3.0 version of Reportsmith to access data in our ERP system. Our ERP is upgrading and going from Oracle 11 database to oracle 12. We are upgrading our Oracle Client on the pc from Oracle 11 to Oracle 12 as well. problem we have now encountered is that Oracle 12 client and Reportsmith 3.0 do not play well together. has anyone run into this issue and found a way around some of the problems...like RTrim and trying to concatenate 3 fields together (like first, middle, last name) into 1 field? R/S also doesn't like derived fields now that we are using oracle client 12. any help is greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
use oracle  11 client again.
you can leave the database on oracle 12.

when upgrading, the oracle database is upgraded first and tested with the original clients
upgrading oracle clients is a separate step

some vendors actually check the version of the oracle client
and some go even further in issueing compatibilty warnings

reportsmith will not be using oracle 12 features, unless you upgrade that too to a version which does
using oracle 11 client on an oracle 12 database is fine in this case
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account