Solved

"Method~of Object~failed"

Posted on 2013-11-25
7
410 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 37

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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 18

Expert Comment

by:Dennis Aries
ID: 39677722
0
 
LVL 37

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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
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…

734 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