Solved

"Method~of Object~failed"

Posted on 2013-11-25
7
413 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 300 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 200 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

623 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