Oracle Connection - Visual Basic .NET

Francis Awofeso

I am new to .NET and I am trying to connect to Oracle database. Can
someone with this experience please describe the steps or process to connect
to Oracle from .Net. I will appreciate it if anyone can recommend a URL or
book or document that described the process. Thanks in advance

Francis Awofeso

Nov 20 '05 #1

Subscribe Reply

2312

Cor

Hi Francis,

He is not there today and probably also not tomorrow however normaly Miha
answers all Oracle questions in

microsoft.publi c.dotnet.framew ork.adonet

To a direct answer connections stings you find in

www.connectionstrings.com

I hope this helps,

Cor

Nov 20 '05 #2

Cor

Nov 20 '05 #3

Paul Clement

On Wed, 7 Apr 2004 13:40:01 -0500, "Francis Awofeso" <Fr************ *@logicacmg.com > wrote:

¤ I am new to .NET and I am trying to connect to Oracle database. Can
¤ someone with this experience please describe the steps or process to connect
¤ to Oracle from .Net. I will appreciate it if anyone can recommend a URL or
¤ book or document that described the process. Thanks in advance

You have several options. I will assume that you already have the Oracle client software installed
an configured.

The following options are available, but I would recommend the .NET providers since you're liable to
get better support for the newer versions of Oracle:

Microsoft or Oracle ODBC drivers with the native .NET ODBC library.
Microsoft or Oracle OLEDB drivers with the native .NET OLEDB library.

Microsoft .NET Provider for Oracle. If you have VS 2003 installed, it is available as
System.Data.Ora cleClient. If VS 2002 is installed you have to download and install the provider:

http://www.microsoft.com/downloads/d...displaylang=en
http://www.able-consulting.com/dotne...ETDataProvider

Oracle ODP for .NET. This is Oracle's native .NET provider. It requires the 9i client.

http://www.able-consulting.com/dotne...iderFromOracle

There are also third-party Oracle providers

DataDirect:

http://www.datadirect.com/products/dotnet/index.ssp

CoreLab:

http://crlab.com/oranet/
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)

Nov 20 '05 #4

Paul Clement

Nov 20 '05 #5

Similar topics

14529

Very slow initial connection on Oracle 8i

by: Harry | last post by:

Using Oracle 8i enterprise on win 2000 (sp3) Installed the standard configuration & whenever I make a connection it takes about 10 secs. It's running on a P1900 with 1gb Ram so no reason there for slowness. Once I'm connected the queries work pretty much instantanously but to connect using SQLPLUS, Toad, ODBC, OLEDB all take about 10 secs. I connect using OLEDB from Visual Basic development environment & after the 1st connection...

Oracle Database

17040

Oracle connection problems; Odbc call failed

by: mcbill20 | last post by:

Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to access any of the Oracle tables on another machine but now I am having problems. Unfortunately, I don't remember the correct syntax for the ODBC connect string and I am hoping that is my whole problem. I am trying to connect to an Oracle 9...

Microsoft Access / VBA

5779

SOS! ORA-03114: not connected to ORACLE && MS's Bug??

by: Ê¹ÃûÑï | last post by:

ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access class. using System.Data.OracleClient;

C# / C Sharp

1554

SOS! ORA-03114: not connected to ORACLE && MS's Bug??

by: Ê¹ÃûÑï | last post by:

ASP.NET

292

Very slow initial connection on Oracle 8i

by: Harry | last post by:

Oracle Database

10384

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10395

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10130

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9204

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7667

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6887

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5692

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3865

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3017

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General