Solved

Connecting to Oracle

Posted on 1998-07-15
7
285 Views
Last Modified: 2010-05-03
I want to know how to connect from VB to Oracle backend. Please point to sites where I can get to see some code examples on how to acieve this.
0
Comment
Question by:Vinod1959
7 Comments
 

Author Comment

by:Vinod1959
ID: 1465883
Edited text of question
0
 

Accepted Solution

by:
ohayden earned 70 total points
ID: 1465884
We installed the Oracle client (Which is on the Oracle server CD) and it installs an ODBC control which you can use in VB to connect to oracle. All you have to do is setup the control and make sure you have the correct TNS files on the client and all will work fine!!! Let me know if you have any problems...


0
 

Author Comment

by:Vinod1959
ID: 1465885
Thank you for that answer. I want some code samples of how and where in the code I should specify ORACLE as the database engine? Pl send me lines of code to illustrate that.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Expert Comment

by:ClarkKent
ID: 1465886
A couple of years ago Oracle released OO4O (Oracle Objects for OLE), a means of connecting to and manipulating data from Oracle using the Microsoft-driven standard of OLE (Object Linking and Embedding).  Whereas with ODBC some Oracle benefits are not accessible, OO4O allows pretty well all benefits of using Oracle as a database behind Visual Basic.

Here is the URL from which to download the most recent release of OO4O (32-bit, I believe):

http://www.oracle.com/products/trial/html/trial.html#objectsforole

The kit includes very clear samples and documentation.

You will also find the entire OO4O kit bundled into the Oracle Lite CD which you can request for free (on a trial basis) from Oracle Corporation.  Just call your local Oracle number.

I would also do a query on the Oracle site while you are there, specifically for "OO4O", on the web, and in newsgroups (Dejanews), for more information.

Good luck!


0
 

Author Comment

by:Vinod1959
ID: 1465887
I had 15 points deleted from account just now for no reason. I  never indicated that I accpted any answer. I want to know why?
0
 

Expert Comment

by:newlook
ID: 1465888
I agree. Oracle Objects for OLE is definately the best way.
If you have Oracle installed at your site you should almost definately have the software for it on a client disk. (it used
to be called Oracle Glue).
To use Objects for OLE it requires you create a database,session
and dynaset(s). Note that if you are used to recordsets that
you have to assign the oracle dynaset to it - direct Oracle
Object OLE recordsets are not available.
There is a control (the Oracle Data Control) available in a similar fashion to the default Microsoft database control -
however you will find it alot more flexible to do the dynaset
creation yourself.

The advantages of using Oracle Objects over ODBC are that you
can use the power of Oracles database directly - packaged procedures etc.

If you need examples / help I will gladly supplu you.
kris@develop-newlook.demon.co.uk
0
 

Author Comment

by:Vinod1959
ID: 1465889
Thanks for the explanation on why use Oracle objects over ODBC. Thanks also for offering to supply examples. I would need that help in the future.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DO Loop not working 4 72
Need VBS version of Excel date conversion 4 64
SQL VB connection works in one PC and doesn't in another 15 57
Added a column screws up code 5 49
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
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 utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now