Error connecting to an Oracle Database from Crystal Reports 9

Posted on 2004-09-03
Medium Priority
Last Modified: 2008-01-09
Hi there,
I'm getting an error trying to connect to an Oracle 9i database via Crystal Reports 9.
I've setup a ODBC connection, tested it out and it connects successfully...
Now when I try to connect to the DB with Crystal Reports, I get an error:

Logon Failed:
Details: HY0101:[Nicrosoft][ODBC Driver Manager] The driver is incapable of supporting the current environment attributes.

Am I missing a step? Do I have to upgrade the driver? The driver I'm using is Oracle in OraHome92

Thanks for your help....
Question by:Classic1
  • 2
LVL 42

Accepted Solution

frodoman earned 200 total points
ID: 11974890
You may need to update your ODBC driver or use an OLE DB connection instead of ODBC.

LVL 10

Expert Comment

ID: 11976998
try to use the driver that crystal recommends for Oracle databases. Go to set datasource location tab in the database toolbar and create a new connection to the oracle database using the driver supported by crystal. Then map your fields if needed. Your report will work fine

LVL 10

Expert Comment

ID: 12159777
I think both answers are right because i am explaining how to get to the odbc connection.


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question