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.