asked on

Any one hav an Idea of this Error -2147217887

I would be the happiest person if someoen solve my problem.

Iam using oracle as backend and VB as frontend.

1. i have table in oracle under a user
2. when i connect to oracle and fetch the records under the table using an recordset visual basic doesnt give an error.
3. but only during runtime, when it encountered the code for displaying the fetched field ( for ex like rec("Dateofjoin") ) it pops me an error -2147217887(80040e21) errors occured
4. This same code is running fine with other user id in oracle.
5. I cannot not figure out whether the error is with vb or oracle .
if anybody can help me out plz

bobbit31

can we see more of the offending code?

ASKER CERTIFIED SOLUTION

RichW

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jwillemssens

Are you using Odbc driver or directly attack Oracle ?

Matti

Hi!

I think you try latebinding someting which is not creatable.

Try reference these objects and stop using "create object"

Matti

DanRollins

Hi vishwa_gv,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

Accept RichW's comment(s) as an answer.

vishwa_gv, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer

SpideyMod

per recommendation

SpideyMod
Community Support Moderator @Experts Exchange