Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

"Method~of Object~failed"

Posted on 2013-11-25
7
Medium Priority
?
419 Views
Last Modified: 2013-12-07
1) We have a 32-bit application written in VB6 that runs as both a desktop client and web application. Due to an upgrade to the back-end, we moved everything to a new environment Windows 2008 and IIS7.

2) It gives me this error:
"Method~of Object~failed"

The error is after the last line of this code:
    Set lcnxxxx  = mobjCtx.CreateInstance("ADODB.Connection")
    Set lobjEncryptPass = mobjCtx.CreateInstance("XXXXSECURITY.clsEncryptPass")
    lcnxxxx.Open pstrcnXXXXX

Note: pstrcmXXXXX= "Provider=MSDAORA.1;Password=xxxx;User ID=xxxx;Data Source=xxx;Persist Security Info=True"

3) It seems to me that the error is regarding the ADODB, how do I solve this?
0
Comment
Question by:Zopilote
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 38

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 1200 total points
ID: 39676996
is the client installed for accessing the oracle ?

looks like you want to use the Microsoft client for oracle
0
 
LVL 18

Assisted Solution

by:Dennis Aries
Dennis Aries earned 800 total points
ID: 39677179
The error 'Method ~ failed for Object ~' usually occurs when you are dealing with either an incompatible version of the libraries or incorrectly registered libraries.

Based on the information provided, I'd suggest reinstalling the ADODB-components.

Furthermore, you mention that your application is 32 bit, but you fail to mention wether the Windows Server 2008 is 32 or 64 bit. If you have installed the x64-client of Oracle, then you will not be able to connect. When you are using VB6 you are required to have the 32bit client installed, regardless of the OS-architecture.
0
 
LVL 5

Author Comment

by:Zopilote
ID: 39677507
Thank you both for your answers.
@geert, I installed the Oracle client 10G, how do I check the Microsoft client is installed too?

@djjaries, Server is 32bit, thus, the Oracle Client is also 32bit. Sorry for this question, how do I reinstall the ADODB components?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 18

Expert Comment

by:Dennis Aries
ID: 39677722
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 39677790
ugh ... you'll have to test with both clients ms and ora
it has happened that one or the other fails or the vendor doesn't support all of the clients
0
 
LVL 5

Accepted Solution

by:
Zopilote earned 0 total points
ID: 39690503
The solution: we needed to upgrade the Oracle Client version from 10.2.0.4 to 10.2.0.5 due to a bug, but this is only possible if you have the Extended Support (which we don't have it).
Nevertheless, we installed the Oracle Client 11.2.0.1.0 and the problem was solved.
0
 
LVL 5

Author Closing Comment

by:Zopilote
ID: 39702879
I am selecting my own answer as the solution because is the solution.  Nevertheless I am splitting points between the answer because first, they did answered, second, they suggested interesting points.
0

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question