?
Solved

Creating Oracle object from VB6

Posted on 2005-03-27
3
Medium Priority
?
772 Views
Last Modified: 2012-08-14
Hi
   I am appointed as a programmer in a textile company, and given some under contsruction project. I hv give the source code but not the activex or dll used with that. I manged it and collected all activex and dll from internet and some other places. The onle remaing thing that is not solved by me is that the old programmer has used the following lines to connect with oracle.

  Set OraSession = CreateObject("OracleInProcServer.XOraSession")
  Set OraDB = OraSession.DbOpenDatabase(mODb, mOUName & "/" & mOPass, 0&)


OraSession and OraDB are declared as Objects. When I run the program it gives the error, that is:

Runtime error 429:
ActiveX component cant create object,
I think that I have not installed some oracle activeX , PLz tell me wht I should do , if the problem is with absence of activex that where i can found those ones,


Thanx

                                                       LeoUmar
0
Comment
Question by:leoumar
[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
  • 2
3 Comments
 
LVL 10

Expert Comment

by:anv
ID: 13641927
Have u installed Oracle client on ur machine??
0
 

Author Comment

by:leoumar
ID: 13641972
I dont know wht u r asking bocz i hvnt much idea of orcale, but i hv intsalled form6i and reports 6i on my machin, and i access data base from our server.
0
 
LVL 10

Accepted Solution

by:
anv earned 400 total points
ID: 13642030
When u need to use Oracle with ur Vb Application... u need to install Oracle client on ur Machine..

Install Oracle Client and then run ur code..

check this link:

http://kb.indiana.edu/data/anjm.html
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

752 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