"Oracle8 ODBC Driver Connect" versu "Oracle SQL" connection
Posted on 2005-03-24
We can connect to our Police Oracle 7 database from our clients running Crystal Reyport 8.5 when using the DSN configured with Oracle 8.01 driver. This works only using Crystal's "Data Explorer", because the server logon dialog box shows "Oracle8 ODBC Driver Connect".
If we try a run the report or do a "Database Verify", the database logon show s a different logon dialog box of "Oracle SQL". When using this connection type we get the following message "Error while trying to retrieve text for error ORA-00000".
How Can We:
change the report or Crystal Reports setup to use "Oracle8 ODBC Driver Connect" instead of "Oracle SQL" logon process when running reports or doing a database verify. Again, the only way we get the Oracle8 ODBC Driver connect is when we use the "Data Explorer." Why is that?