Crystal XI r2 with Oracle 11g
My company's reports use the crdb_ado.dll driver for running reports against clients with oracle databases. We haven't had any trouble with this on oracle servers that are 10 and below. One of our clients is testing out moving up to an oracle 11g server and we are running into problems with our report connection.
We are currently on version 22.214.171.1241 of crdb_ado.dll. Is there an update to this driver that is compatible with this latest oracle server version, or should I be using another driver for this altogether?
The error we are getting is "Logon failed" after a prompt to enter database information (this prompt shouldn't even be coming up since we set connection info in the application). The connection information is being set correctly in 10g and below (I have the 9i client on my testing machine, but TOAD is still able to negotiate a connection to up to 11g). I will try using a machine with the 11g client and see how that works out.
I've tried setting the driver to crdb_oracle.dll, but with the same results. The crystal designer application cannot seem to negotiate a connection with this DB server either, giving me the same logon failure message. I've tried the "Oracle Server", "Oracle Provider for OLE DB" and "Microsoft OLEDB Provider for Oracle".