Join Now For immediate help use Live now! This means that you cannot have PeopleTools 7.5 and PeopleTools 8 on the same machine and expect Crystal Reports to work with both PeopleTools builds. As far as I understand it you have to install both Oracle 64 bit and 32 bit client._________________Next Available for Contract Work - August 2017 Business Objects Versions 4,5,6, XI R2, But in fact, you should never place a 32-bit oracle home in the same oracle base as a 64-bit oracle home (the base being c:\app in your example) because if you have a peek here
If you have experience with BO 4.x and Oracle integration you can share with the community, i'm sure folks would appreciate it. Can you suggest a workaround for this Thanks and Regards Vijaya Reply Ron Keler says: October 30, 2013 at 5:05 pm Hi Vijaya, this post is specifically about the BO server You will find that this performs better. I have been reading other forums and it seems that our Oracle client is 64 bits while the Crystal Report is 32 bits and that seems like the issue. https://blogs.sap.com/2013/05/31/crystal-reports-2011-on-bi4-platform-oracle-drivers-settings/
I recommend installing the 64 bit as Admin and the 32 bit as Instant Client. ID: 400479362014-05-07 Are you recommending that I uninstall the 64bit 11g Client all together before installing the 32bit one? 0 LVL 101 Overall: Level 101 Crystal Reports 95 Message Active Now we are facing an issue regarding reports refresh from BI launch Pad from the universes based on Oracle. For Crystal 2008, the path is C:\Program Files\Business Objects\BusinessObjects Enterprise xx\win32_x86.
Furthermore, I indicated I have experienced issues having multiple versions of Oracle on the same machine. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. Thanks for all your help and sorry for the delays in updating &closing this case. 0 Message Author Comment by:Roberto Madro R. Peoplesoft 9.2 Crystal Reports One point to be noted is connections are working for others with same tnsentry who have installed only 32 bit driver.
I've created a shortcut to mine, which is C:\Windows\SysWOW64\odbcad32.exe FYI, I just tested it. 0 LVL 101 Overall: Level 101 Crystal Reports 95 Message Active today Expert Comment by:mlmcc ID: Oracle Server connection gjwl_8 wrote: Mak 1 wrote: gjwl_8 wrote: Mak 1 wrote: ODBC is what you use if you have no other way to connect . To test your configuration, make sure you execute the tnsping.exe and/or sqlplus.exe commands from each directory separately to assure both clients are working properly and can connect to your database. check this link right here now You don't really need to set the ORACLE_HOME at all.
Do you need both? Crystal Reports In Peoplesoft mlmcc 0 Featured Post PeopleSoft Has Never Been Easier Promoted by WalkMe PeopleSoft Adoption Made Smooth &Simple! Do you agree? Install the PeopleSoft ODBC Driver and Crystal Runtime.
Reply Ron Keler says: November 13, 2013 at 9:14 pm Chris, on windows, from command prompt (which is what i assume you are using), sqlnet.ora is not an executable, and if this website Interlink/JDeveloper tab by selecting select Start, then select Programs, then select PeopleTools 8.5x, then select Configuration Manager. Peoplesoft Crystal Reports Tutorial It worked for me one time on my workstation but then when I tried the same thing on a different workstation with my account on a same domain, it did not Installing The Peoplesoft Odbc Driver And Crystal Runtime As an alternative, if you are calling CR from an application, have you application gather the information and then push it to CR using the setDataSource.
Thanks - Ron Reply Leave a Reply Cancel reply Your email address will not be published. navigate here Apart from the driver, you can also change the database name or the user id but don't change any other rows in the file DSN. Anyone else having this issue...? Join Now For immediate help use Live now! How To Connect Crystal Report To Oracle Database
Claim Your Free WalkMe Account Now Free Trial Question has a verified solution. You should do some searching on the web for the particular ora error you getting. How should I setup the Database Configuration on BOE so that the report runs?? http://pspfull.com/crystal-report/crystal-reports-odbc-connection-sql-server.html You should use the native Oracle Server connector as this is a driver written specifically to connect to Oracle.
The BI4 Platform is using a 64bit Oracle driver while Crystal Reports 2011 client is using a 32bit driver. ID: 400996312014-05-29 I've requested that this question be closed as follows: Accepted answer: 0 points for codedigger's comment #a40071168 for the following reason: It was a matter of disntiguishing between the BUT, I can't get the report to run on BOE.
Enter User ID and Password. Thx 0 Comment Question by:Roberto Madro R. Thank you very much. Not sure what else to suggest?
CMS/AUDIT starts OK connecting to Oracle. (CMS is 64-bit service) Crystal Reports can be run and viewed OK when SCHEDULE and View INSTANCE is used. (AdaptiveJobServer is 64-bit service) Reports FAIL Serah Muiruri November 25, 2011 at 22:33 PM 0 Likes Not what you were looking for? Install the Oracle driver (I went for 11g, the latest one). http://pspfull.com/crystal-report/crystal-reports-oracle-server-connection.html Draggable resizable popup in SAP Dashboards (Xcelsius) → 7 Responses to Sorting out Oracle connectivity on BusinessObjects 4.0 Tina Bahm says: June 7, 2013 at 5:02 pm you are referring to
Does anyone know what is the difference between them and which option is better??? Back to top gary_scottPrincipal MemberJoined: 17 Dec 2004Posts: 151Location: Gloucestershire, England Posted: Thu Jun 28, 2012 3:41 amPost subject: Re: Oracle 32 and 64 bit drivers side-by-side (Windows 2008) Hi, Please