We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Connecting to Oracle

Vinod1959
Vinod1959 asked
on
Medium Priority
309 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.
Comment
Watch Question

Author

Commented:
Edited text of question
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
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.
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!


Author

Commented:
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?

Commented:
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

Author

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.