"Method~of Object~failed"

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?
LVL 5
ZopiloteAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ZopiloteConnect With a Mentor Author Commented:
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
 
Geert GruwezConnect With a Mentor Oracle dbaCommented:
is the client installed for accessing the oracle ?

looks like you want to use the Microsoft client for oracle
0
 
Dennis AriesConnect With a Mentor CEO @ Arkro ITCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
ZopiloteAuthor Commented:
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
 
Dennis AriesCEO @ Arkro ITCommented:
0
 
Geert GruwezOracle dbaCommented:
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
 
ZopiloteAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.