| An error occurred while attempting to connect to your database: Illegal char "> at index 0: "C:\Oracle\client\product\12.2.0_x64\client_1\network\admin\ojdbc.properties |
I don't have ojdbc.properties file in the above location, but I don't think I ever had one.
I created an empty ojdbc.properties file in that location as well, but that didn't change the error message.
I tried JDBC, Oracle .../12c/..., Oracle .../12c/... - OCI types of connections. Same message from all.
I also had existing server registrations which were working just fine few weeks back but have now failing with the same error message.
Any help and/or pointers would be highly appreciated. Thanks.
Response
Lisa Waugh 6 months ago
To make an Oracle OCI Connection, you need to ensure that the Oracle JDBC drivers used by ADS are build compatible with the Oracle version you have installed on your machine.
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation22.2/page/Oracle-JDBC-Drivers/Oracle-JDBC-Drivers#oracle_jdbc_driver_location_12c_2
I just replied, but I am using a version that is not out yet. Let me send you that help file. Sorry
Try this one.
www.aquaclusters.com/…/Oracle-JDBC-Drivers
Go to the bottom of the page and
MULTIPLE ORACLE CLIENT DRIVERS IN WINDOWS PATH
Be aware that if more than one Oracle client has been installed on the same computer as Aqua Data Studio, you must make sure that only one Oracle Client appears in the windows path. Having multiple versions of the OCI DLLs in the path will prevent Aqua Data Studio from successfully connecting and will generate an error message similar to the following when attempting to make a connection: Which is the exception error.
Thanks Lisa for the link. I went through the link before. I have only one Oracle client installed and I don’t care about OCI. More importantly, I explicitly state which ojdbc driver to use in JDBC server properties and it was working fine. So I am not sure what changed. I don’t have write access to the folders the link is asking me to modify, but I will create TKT for our admin guys to try.
I see the following in Help->About-> JDBC Drivers:
Yes, I would recommend opening an issue so they can collect all the support information.
In order to diagnose the issue please use your Help > Support Information and your log files located in Help > View Log > Archive > Explore. When you open a support issue using the “Help>Technical Support>customer support portal”
This will provide the information to help diagnose the issue. Thanks!