on 07-25-2011 12:20 AM
Let me apologize up front for this total newbie question. I am just getting started with Crystal Reports and I would like to know the process for connecting to Oracle databases.
I can connect to the example database Xtreme.mdb just by selecting the database files and without having the Microsoft Access database software installed.
Would I be able to do the same with an Oracle database? Would I be able to remotely develop some reports for a client where the client has the Oracle application but I would have only the database files?
Thanks,
(newbie) Loran Kary
Hi there,
You need to establish an ODBC connection to get connected to your database.
Go to your Control Panel and open Administrative Tools -> Click on Data Source(ODBC). On the User DSN tab, select a driver for which you want to set up a data source by clicking on the Add button. Once done, the ODBC setup dialog box appears. Provide your database login details and clik ok..Your ODBC connection is done.
Next open your Crystal Report application(a blank report)not sure which version you are using, in my case it is Crystal Report XI Release 2. On the Database Expert, expand Create New Connection. Expand ODBC(RDO) , it will take you to the Data Source Selection. Select the datasoure name and click Next. Here, you need to give the login credential for accessing the Database. Once done, you will find the data available on the Crystal Report.
Regards
Cauvery
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also note, you must have the Oracle Client installed on your local PC which has access to a Oracle Server to be able to create reports off or Oracle. In a round about way you could continue to use Access or any other DB and then your customers could map the reports to Oracle, most of the time it will work but sometimes due to field type differences between databases mapping field doesn't always work properly. Your customers would have to "fix" up your reports which is kind of messy.
Or rather than using ODBC you can Install the Oracle Client and it will allow you to connect to their DB once a VPN tunel or Remote Desktop connection is made. It's better to use the Oracle Native Client or OLE DB rather than ODBC, ODBC adds another layer on top of the client. But at the same time there are differences between the way ODBC, OLE DB and Native work, it's more of what you are used to.
CR cannot connect directly to an Oracle file, must go through a Client connection.
Thank you
Don
Hi John,
It should be on your Oracle CD and CR requires that you use the 32 bit client for CR Designer and if using CR for VS 2010 64 bit applications then the 64 bit client is required on the app server. If you are using CR 2011 and publishing the reports to BOE 4.0 then the 64 bit client needs to be installed on the BOE Server. BOE 4.0 is 64 bit only and 32 bit on the local PC for CR 2011 to connect.
I don't believe the Oracle Client is free to install so not sure what it is and if you'll be able to find it, legally anyways. Check Oracles Site and use what is available from them.
If you use the Data Direct CR 5.3 install then you can use the Wired Driver, it has the client built in.
Thanks
Don
Don, i seem to have a problem i cannot resolve.I first loaded the 32 bit oracle client, and it installed correctly.
But when i open the windows ADMIN TOOLS / ODBC Administrator, i do not see any drivers installed, when i select "system dsn" other than SQL server.
So i loaded the data direct odbc 5.3 drivers for windows. They also installed ok, but again i do not see any drivers in the ODBC ADMIN tool ???
i am using windows 7 and have crystal 2008 version 12.3.0.601
Any ideas ? thanks for your help
Well Don, do i get points for answering my own question ???
In win7, if you open the ODBC ADMIN it only shows 64 bit drivers.
Of course i have downloaded 32 bit drivers for Oracle and the DataDirect 5.3
If i run c:\windows\sysWOW64\odbcad32.exe this shows a 32 bit ODBC admin windows, and all the 32 bit drivers are there !!!
very frustrating, so i just created a shortcut to c:\windows\sysWOW64\odbcad32.exe and called it "32 bit ODBC CONFIG"
However, where do i place the tnsnames/sqlnet ora files for DATADIRECT ?
Thanks John
Hi John,
If the 32 bit Oracle Client is installed then in your PATH statement it should it in there and CR and the client will find your ORA files.
Are you getting a 126 error in ODBC when trying to create or test your DSN? If so then it's because the Oracle Client can't be found by ODBC.
Not sure about answering your own question, this is a Microsoft platforms issue. You should have a 32 bit Control Panel where the short cut is located.
On Windows 7 from Start and the search line simply type in ODBC and both short cuts should be listed.
I also recall someone else had the problem where the 64 bit client was installed first, to fix it they had to uninstall both 32 and 64 and then install 32 bit first....
Thanks
Don
Don, i am now ok. It was the odbc admin tool causing my problem.
I am fine using the Oracle client.
In the 32 bit odbc admin window, how do the datadirect drivers appear ,
i.e is CR nnnnnn ODBC DRIVER 5.3 a datadirect driver ?
if i use the cr oracle odbc driver 5.3 i get a dialog box which i complete, but then get a ORA-12541 TNS:NO Listerner
Thanks
Hi John,
Correct, they are listed as CR.... in the ODBC Admin when adding a driver.
You still need to configure the Oracle Client. Try a re-boot, sometimes the client can't be found until a reboot is done.
Do you see OCI*.exe running in the Task Manager? Does SQLPlus work?
Try the Wired Driver, it prompt for all of the Server info.
Don
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.