Skip to content

Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Oracle Errors in VBA application post 19c upgrade

edited January 2022 in Database Install/Upgrade/Opatch (MOSC) Question

Hi Team,

We have an excel based VBA application that have Database connectivity. Recently our DB got migrated to 19c database, and we are facing issues post the upgrade

As part of the upgrade we 

1. updated the client version used by the application to 12c client (32 bit), previously it was using 11g client.

2. updated the provider in database connection string as OraOLEDB.Oracle, previously it was using MSDAORA.

we are able to login to the application and perform basic operations like add, delete and update a user detail.

But queries that have date driven logics are failing.

eg : the query select count(*) from TABLE1 where TABLE1.POLICY_NUMBER = '9823746586' and TABLE1.EXTRACT_DATE = '29-Jun-2021' and TABLE1.VERSION_NUMBER = '13' // should return 5 but we are getting the count as 0 from Excel vba application.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center