on 10-14-2008 4:00 PM
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 11.5.9.1101 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".
Thanks,
Chuck Reed
Yes, I have TOAD installed and it can connect and query the connection I am using.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chuck,
You are using Crystal Reports XI R2, this will not support Oracle 11g. It supports the following databases :
Provider Name Data Connector Unicode Support
Oracle 10g R1 (10.1)
Oracle Net Client 10.1 Yes
JDBC Oracle 10.2 Yes
ODBC Oracle 10.2 Yes
OLEDB Oracle 10.2 Yes
Oracle 10g R2 (10.2)
Oracle Net Client 10.2 Yes
JDBC Oracle 9.2 Yes
ODBC Oracle 9.2 Yes
OLEDB Oracle 9.2 Yes
Oracle 9.2
Oracle Net Client 9.2 Yes
Hope this will help you
Thanks,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chuck,
Can another program connect to Oracle 11G? Something like SQLCON if you download it or MSQuery or Access?
I'm wondering if it may be a problem with the install. Check to make sure the Oracle folder is in the system's path.
Good luck,
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.