in my application I use the SQLConnect function to connect a ORACLE database.
Sometimes in SQLPrepare I have a SQL error (32767 ORA-03313 or ORA-24324).
In this case I try to re-connect to DB with SQLConnect in a loop waiting the network restart, but SQLConnect returns Always TRUE.
Thanks in advance
- Founder/Site Admin
- Posts: 2868
- Joined: 24 Feb 2017, 09:12
- Location: Gouda, The Netherlands
It seems that when using Oracle (maybe other DB brands also?) the connections are cached in some way.
So it might that subsequent connects are first internally fetched from a cached resource which will then be reused without actually performing the connect.
In your case, the previous connection is reused without doing a real connect which will return you TRUE on the connect.
(but this is just a hunch).
See the other case, where connect returns TRUE even when it should not:
Who is online
Users browsing this forum: [Ccbot] and 0 guests