Home > Crystal Report > Crystal Reports 2011 Oracle Driver

Crystal Reports 2011 Oracle Driver

Contents

ID: 400550422014-05-09 I'm running win7 on a 64bit too, and from the run / command line odbcad32 brings up the ODBC Admin, that's where I'm building those conenctions, and I'm thinking Default Crystal Reports This option enables you to specify the default location of your Crystal reports. Thanks - Ron Reply Leave a Reply Cancel reply Your email address will not be published. When you run a preexisting report, you sign in to a PeopleSoft database using the PeopleSoft sign-in dialog. Check This Out

You should do some searching on the web for the particular ora error you getting. The poster obviously disregarded this information and chose to attempt a workaround by having both 64-bit and 32-bit Oracle tools installed, which complicated matters further. Install the Oracle driver (I went for 11g, the latest one). But I need to set this up in 6 different workstations and I am not able to succeed.

Peoplesoft Crystal Reports Tutorial

You'll need to update your install to include the Oracle driver. 2. In an oracle based environment, this can be the source of much confusion.  While the platform itself (the CMS and Audit databases connections) support 64bit oracle driver connectivity, other BO tools OK, I'm able to connect using Oracle Server connector on my workstation. Thanks Back to top MJRBIMForum EnthusiastJoined: 23 Mar 2007Posts: 1117Location: Toronto, Canada Posted: Tue Jul 10, 2012 2:17 pmPost subject: Re: Oracle 32 and 64 bit drivers side-by-side (Windows 2008) We

Back to top SchusterForum AssociateJoined: 29 Aug 2002Posts: 548Location: UAE Posted: Mon Feb 10, 2014 9:00 amPost subject: Re: Oracle 32 and 64 bit drivers side-by-side (Windows 2008) Khan, Did you I opened the one from SysWow64 and noted I had no connections defined but the one that opened when I just typed odbcad32 in the command prompt had a connection defined Don't forget to put the Oracle tns names on the server, also. I do have the Oracle client on the BO server but it still fails to connect. Peoplesoft 9.2 Crystal Reports At moment these are test servers, plan to install on production servers soon.

Installing the PeopleSoft ODBC Driver and Crystal Runtime If you have installed Crystal Reports 2011 or Crystal Reports 2008 on your Microsoft Windows-based development workstation, refer to the PeopleTools Installation Guide I had to reinstall crystal reports and works again. Looking for answers on SAP Community Network made me realise that I wasn't the only one not being able to figure out why I was getting errors like "The viewer could Back to top Mak 1Forum AficionadoJoined: 06 Jan 2005Posts: 13911Location: London Posted: Thu Mar 21, 2013 5:22 amPost subject: Re: ODBC vs.

Basically the Path needs to indicates where the oracle home is. Crystal Reports In Peoplesoft Install the 64 bit Oracle driver first. Required fields are marked *Comment Name * Email * Website Search for: Archives March 2017 September 2016 June 2016 February 2016 November 2015 July 2015 May 2015 March 2015 January 2015 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

How To Open Crystal Report In Peoplesoft

Not sure what else to suggest? Back to top MJRBIMForum EnthusiastJoined: 23 Mar 2007Posts: 1117Location: Toronto, Canada Posted: Mon Oct 15, 2012 11:50 amPost subject: Re: Oracle 32 and 64 bit drivers side-by-side (Windows 2008) I don't Peoplesoft Crystal Reports Tutorial For instance, you cannot get PeopleTools 7.5 Crystal Reports to work with the PeopleTools 8.x PeopleSoft ODBC driver. Installing The Peoplesoft Odbc Driver And Crystal Runtime You probably need R2 32-bit.

Join & Ask a Question Advertise Here Enjoyed your answer? his comment is here All Rights Reserved. thank you, rampa IP Logged lockwelle Senior Member Joined: 21 Dec 2007 Online Status: Offline Posts: 4254 Posted: 23 Oct 2009 at 6:48am for the simplest of Glad to help and I hope you'll manage to solve the issue.

Matt like (0) Leave a Reply Cancel replyYou must be logged in to post a comment. How To Connect Crystal Report To Oracle Database

Search or use up and down arrow keys to select an item. I am trying to connect to Oracle 11g database using JDBC driver. Navigation Access the Crystal/Bus. this contact form ID: 400996522014-05-29 Many thanks 0 Featured Post On Demand Webinar - Networking for the Cloud Era Promoted by Experts Exchange This webinar discusses: -Common barriers companies experience when moving to the

BUT, I can't get the report to run on BOE. There could be any number of issues related to why you are unable to connect to your oracle DB, some common issues are related to having multiple oracle homes and not To be clear - I am NOT talking about any of the Client Tools in this scenario...this is all within the SIA-managed services.

I recommend installing the 64 bit as Admin and the 32 bit as Instant Client.

They would refresh O.K on client PCs (which have 32 bit oacle client). Thank you very much. Oracle Server connection gjwl_8 wrote: I noticed if I use the native Oracle drivers, the datasource is set to the name of my instance. Facebook Twitter LinkedIn https://www.experts-exchange.com/questions/28428460/Crystal-Reports-2011-DataSource-connection-issues.htmlcopy [X] Welcome to Experts Exchange Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Is it worth considering the upgrade? Thx 0 LVL 101 Overall: Level 101 Crystal Reports 95 Message Active today Expert Comment by:mlmcc ID: 400549272014-05-09 How are you creating the ODBC connection? Cystal Reports 2011: Make sure that the Database Configuration is correct (In CMC) - check if the report is looking at the right DSN file, has the correct username and the navigate here ORA-12154.

It is in Windows/SysWOW64 Look for odbcad32.exe mlmcc 0 On Demand Webinar: Networking for the Cloud Era Promoted by Experts Exchange Ready to improve network connectivity? Click next and it prompts for user credentials. Image: Configuration Manager - Process Scheduler dialog box This example illustrates the Configuration Manager - Process Scheduler dialog box and the Crystal Reports (CRWRPTPATH) field is set toZ:\PT8.5x\crw: See Configuring User Both tools look the same.

In my experience this installation methodology worked great! Note: If you are creating a Crystal report from PeopleSoft Query and this path is invalid, you will receive an error message. Well, if you are looking to have the client tools installed on a server (in a development environment for example), or are deploying crystal reports that leverage oracle 32bit client connectivity, 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.