asked on

Cannot Connect Crystal Reports 2008 to Oracle 11g

I have a new Win2008R2 Server with the full Oraclient Installed. The Vendor Application is installed and working against the dB. Everything is located on the same machine. When trying to connect to the Oracle DB I get an error stating the OLE DB will not work until the oracle client is installed. The full Client is installed, so im not sure why that message. Im just trying to connect to the db to write a report against the DB. In SQL Server its a super easy thing to do.....but Oracle not so much. I tried creating an ODBC connection. (Just to get the report written and deal with OLE DB later and it lets me create an ODBC entry.) but when i try to consume the odbc connection in Crystal is bombs out as well.

Im not an oracle guy. I dont know anything about the DB platform other than SQL Server is much easier to use. I reiterate, i am not an Oracle user. Ive been thrown this in my lap and have to figure it out with no help. Please be very basic and assume nothing when asking any followup.

Im not new to Crystal but Im brand new to Oracle. Never have used it.

Please help.

vasto

Try to use an ODBC connection. There might be one in the system created when your vendor app was installed..

Mike McCracken

Are you using a 32 or 64-bit connection?

mlmcc

andretix

ASKER

I tried the ODBC Connection and was able to create one. It asked for the service name, user name and password and verified successfully. When I went into Crystal 2008 to create a datasource connection it tells me there is a mismatch. See the error attached.

vasto

Did you check what mlmcc was asking ? Are you using 32 or 64 bits machine ?

andretix

ASKER

Im not sure about the connection. And in my oppinion therein lies the issue. I didnt install this instance of Oracle. But this part i do know.

Oracle 11g

Windows 2008 R2 Server 64bit

Vendor Application runs against database with no issues

Oracle Client is installed

I have Service Name, User and Password

The only option in datasource connections is Microsoft OLE DB for Oracle... I didnt see a native oracle connection.

vasto

check this thread:
http://scn.sap.com/thread/1946394

andretix

ASKER

vasto: I tried that already. Oddly enough I couldnt find a separate ODBCadmin32.exe. The one in the mentione location which is supposedly for 32bit application seems to be the same one that gets called with i navigate via the control panel. the file is in the correct location. Normally the calling program wouldnt even see the connection if it was a 64 bit connection, but in this case, I am able to select the datasource from the list of available DSN, but then get this error.

vasto

Kurt probably will be able to help wit this.

You may also check this link:
https://www.experts-exchange.com/questions/27193219/ODBC-drivers-Oracle-11g-client.html

andretix

ASKER

So i did some more digging. I finally found out how to check which ODBC Admin I was running. The location alone can be deceiving. When I then tried to create a new datasource within the 32 admin it stated that the Oracle Components needed to be installed.

Which tells me that I need to install the 32 Oracle Client. At that point I could probably connect with ADO instead of RDO. Does that make sense to anyone? And If I do need to install the 32 bit client (I know i can download it from Oracle) does that affect the current install of Oracle? Can the 32bit and 64bit co-exist?

andretix

ASKER

vasto: I checked that link. Its not the same situation as me. I have an oracle 64 client installed and I need to use 32bit drivers to connect to crystal which is a 32bit application. Thats sounding more like the crux of my issues as i do more research.

vasto

Sorry, andretix I don't know if it is safe to install additional driver. I personally would not take any risk on a production server. May be other experts will be able to help tomorrow.

ASKER CERTIFIED SOLUTION

Kurt Reinhardt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

andretix

ASKER

Thank you, my suspicions have been confirmed. The only question not answered was if I can install both the 64 bit client AND the 32 bit client on the same machine. You mentioned that it was not a good idea to have multiple versions of oracle on a machine.....is that the same thing?

Also, there is only one application running on this machine. It is not using the oracle client that I know of. They are connecting to the DB using a connection string in VS2008. Its a webserice project. Do I even need he 64bit client?

vasto

How you are going to use the report, from the same application?

Kurt Reinhardt

You can install both 32-bit and 64-bit clients on the same machine, but don't expect them to work out-of-the-box. You may have to do some configuration.

As for the question pertaining to VS2008, I don't know.