Using connection string to access Oracle database

[Former Member]

         In Crystal Reports Designer, I select File>>New>>Blank Report and the Database Expert appears.  I click Create New Connection and ODBC(RDO).  I select the radio button next to 'Enter Connection String' and I enter a connection string to attempt to connect to an Oracle Database and I get the message "Logon failed.  Details: Cannot find DSN in connection string"  Is it possible to use the 'Enter Connection String' option to connect to an Oracle database?  I attempted using the following:  User Id=Oracle1;Password=Oracel1PW;Server=10.42.10.16;Direct=True;Sid=POC1;Persist Security Info=True

Thank You

[DellSC · Accepted solution]

1.  Make sure that you have the 32-bit version of the Oracle Client installed - even if the machine you're working on is 64-bit.  Crystal is 32-bit software and will only work with 32-bit database clients.

2.  If you're going to use ODBC, you need to create a 32-bit ODBC connection prior to trying to use it.

3.  Since you're connecting to Oracle, you should try using the Native Oracle connection instead of ODBC - it will be faster and, generally, you'll get better results with it.

-Dell

[Former Member · Accepted solution]

I can connect to my oracle database if I select 'Select Data Source' and pick the Data Source Name from the list.  What I want to do is to be able to select 'Enter Connection String' and provide the Connection String in the text box to create the connection.  I am wondering if this is possible with an Oracle database and what is the proper format of the connection string?

[Former Member · Accepted solution]

I was able to resolve this by creating an incident with SAP.  A support tech pointed out that when scheduling a report from the CMC there is a Database Logon page where I can enter credentials to connect to the database.  When I filled out the values in that page and scheduled the report it ran successfully