Hello, we have Clarion 6 applications running and connecting to Oracle 11g XE with 11g Client.
I am carrying out tests to use Oracle 21c XE, using Client 21c 32bit, but the applications do not connect to the new database.
I tested positive using Windows ODBC AD 32bit drives for test connection.
Any tips?
One trick is to create a dictionary using the ODBC data source you tested with to import one of the files.
Then wizard an app using that file.
If that app connects, then filename{Prop:ConnectString}, somewhere in a procedure that uses the file, will give you the proper connect string without needing to use the ODBC driver.
My database was recently upgraded from 11 to 19. Upgrading the client was essential: the 11 client cannot connect to the 19 database. But sounds like you’ve dealt with that.
I also installed 19 XE on my home computer, and the main thing I noticed there was that XE sets itself up with “pluggable” databases (PDB) by default, and this has an impact on how you log on. A normal user can only log on to the pluggable database on which they are set up. If you want to log into the root you need to be a “common” user (which in this sense means special, allowed to log into the “common” area"), and the user name starts with c##. I haven’t played with it that much, so can’t give you more guidance.