connection to Crystal Reports

[ICSFAB]

I am looking for configuration information for connection to Crystal via ODBC or Oracle's native connection utility. <br>
<br>
I also need to know how to find the data source name. SQL.Net connection string for an ODBC connection to Oracle8 database. I have not worked Crystal or ODBC off an Oracle system, and have very limited (over the shoulder) experience with Oracle and UNIX.

 

[mdehe]

Were you able to come up with an answer to your question?

 

[editips]

I dont think you can connect to crystal reports with Oracle native connection, I have worked using odbc and done extensive reporting using oracle and crystal. If you are using ODBC try to use microsoft odbc driver for Oracle. You have to create a DSN mentioning the database.

You can see the DSN name in the control panel, ODBC.

 

[jimbopalmer]

BTW if you are not commited to Crystal, I find Business Objects very pleasent I love everyone til they prove otherwise, sadly some prove otherwise SO quickly

 

[Guest_imported]

this should work
CrystalReport1.Connect = &quot;DSN=mydata&quot;;UID=scott&quot;;PWD=tiger&quot;;SERVER=mydata;&quot;