Error connecting to an Oracle Database from Crystal Reports 9

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....
Classic1Database AdministratorAsked:
Who is Participating?
 
frodomanConnect With a Mentor Commented:
You may need to update your ODBC driver or use an OLE DB connection instead of ODBC.

frodoman
0
 
ebolekCommented:
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

Regards
Emre
0
 
ebolekCommented:
I think both answers are right because i am explaining how to get to the odbc connection.

Regards
Emre
0
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.

All Courses

From novice to tech pro — start learning today.