Oracle connection

Francis Awofeso

Please if anyone with experience with VB.Net and Oracle can describe the
steps it will take to connect to Oracle, or can refer me to a link where I
can lookup the ateps or process required to connect to Oracle database. Also
references to any booksor documentation will be appreciated.

Thanks

Jul 21 '05 #1

Subscribe Post Reply

1311

William Ryan eMVP

www.connectionstrings.com

Basically, declare a new connection object with a valid conne tion string.

OracleConnection cn = new OracleConnection("YourConnectionStringHere");

Once you have your connection, you'll want to do something with it so you'll
need a command object or a dataadapter which will need at a minimum a select
command object.

Command's have many methods lik command.ExecuteReader (will fire a
datareader) .ExcecuteScalar (will return one value), ExecuteNonQuery
(execute Insert/delete etc). This is a very simplified view, but it should
get you going.

Just google on ADO.NET, there are tons of examples.

HTH,

Bill
"Francis Awofeso" <Fr*************@logicacmg.com> wrote in message
news:uW**************@TK2MSFTNGP12.phx.gbl...

Please if anyone with experience with VB.Net and Oracle can describe the
steps it will take to connect to Oracle, or can refer me to a link where I
can lookup the ateps or process required to connect to Oracle database. Also references to any booksor documentation will be appreciated.

Thanks

Jul 21 '05 #2

William Ryan eMVP

Please if anyone with experience with VB.Net and Oracle can describe the
steps it will take to connect to Oracle, or can refer me to a link where I
can lookup the ateps or process required to connect to Oracle database. Also references to any booksor documentation will be appreciated.

Thanks

Jul 21 '05 #3

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...

Oracle Database

Oracle ODBC connection problem

by: SerGioGio | last post by:

Hello, I am going nuts. I am trying to connect to my local ORACLE instance using ODBC. It used to work few weeks ago, but it fails now. Connection with: - SQL*plus: connection works! -...

Oracle Database

ASP / ADO / Oracle connection problem

by: Cliff Cooley | last post by:

Can anybody suggest what may be causing the following problem ? I have an ASP script that opens a connection to an Oracle database using a DSN connection string, such as : Set dbConn=...

ASP / Active Server Pages

Export Access Data to Oracle

by: Andrew Arace | last post by:

I scoured the groups for some hands on code to perform the menial task of exporting table data from an Access 2000 database to Oracle database (in this case, it was oracle 8i but i'm assuming this...

Microsoft Access / VBA

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...

Microsoft Access / VBA

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...

C# / C Sharp

Clear text passwords and Oracle - arrrrrrgh - please help!

by: Anonymous User | last post by:

Hi, I am working on a mobile application that consists of a number of handheld scanners, an Xml Web service and an Oracle 9i database in a highly secure environment. The .Net Compact Framework...

ASP.NET

OBDC Oracle connection in a ASP.net web page

by: Ben | last post by:

Hi, I have a problem connecting to Oracle using and ODBC connection in a ASP.Net web page. The TNS Names works fine because when I create a DSN it works, and it works in SQL Plus. Here are...

ASP.NET

Does 2.0 still require ODP.NET to connect to Oracle?

by: D. Patrick | last post by:

I need to connect to an Oracle database. I've never done it before. I see that with framework 1.1 you had to download ODP.NET from Oracle's site in order for the framework classes to even work....

C# / C Sharp

HOWTO Run multiple SQL statements from ASP/ADO to an Oracle 10g.

by: =?Utf-8?B?QVRT?= | last post by:

HOWTO Run multiple SQL statements from ASP/ADO to an Oracle 10g. Please help, I'm trying to write an ASP page to use ADO to run a long query against an Oracle 10g database, to create tables,...

ASP / Active Server Pages

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Similar topics