Hi
We upgraded Oracle to 12 yesterday. We are using Servoy 6.1. At first some of the users had connection issues and I started checking my connections in Servoy Developer and Aqua Data Studio. I definitely was getting Oracle errors in both applications (although different in both) and so figured it must have something to do with the JDBC drivers. Had to attend a meeting but in the meantime noticed that I had no problem connecting as a user to our Servoy applications and then found out that my users were also able to connect. So I believe for the users the issue might just have been that they needed to restart their machines as there might have been something stored in their cache that prevented them from logging in.
But the ADS and Servoy connections on my machine were continuing. The error I was getting on Aqua Data Studio was "ORA-28040: No matching authentication protocol". Eventually I resolved this by updating the JDBC driver. I figured that would do the same for Servoy Developer. There though the error was "ORA-00922: missing or invalid option tips". Changing the driver didn't help here. What I did find finally allowed me to make a connection was removing the 'Schema' parameter. This is not a real solution of course and Servoy warns that one always should give a schema name. Plus for one of my connections it shows no tables even though the connection is allowed without the schema.
Anyone have any suggestions? Why is it working on the server - even without changing the driver - and yet not on my Servoy Developer connection?
Any help greatly appreciated…
John