?
Solved

Creating Oracle object from VB6

Posted on 2005-03-27
3
Medium Priority
?
779 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
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…
Suggested Courses
Course of the Month12 days, 23 hours left to enroll

580 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