In Crystal do the following:
1. Go to the Database menu and select Database Expert.
2. Click on the '+' next to "Create New Connection".
3. Wait for the list to come up and scroll down to click on "Oracle Server".
4. Under "Service" enter the TNSNames alias for your database.
5. Enter User ID and Password.
Two things to note:
1. If "Oracle Server" is not on your list of possible connections, the driver wasn't installed when Crystal was installed. You'll need to update your install to include the Oracle driver.
2. The Oracle client software MUST be installed on the computer where Crystal is running. The driver in Crystal is just a connector between Crystal and the Oracle client - it is NOT the Oracle client itself.
Also, the ODBC connection that lockwelle mentions is slower than the native Oracle connection and doesn't give you access into Oracle-specific SQL for things like SQL Expressions.
-Dell
IP Logged
