Solved

"Method~of Object~failed"

Posted on 2013-11-25
7
404 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
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

840 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