Connecting to Oracle8i with ODBC?

John

Does anyone have an example of how to connect to an Oracle 8i DB and run a
simple select through ODBC? What DLLs should I need?
Assume that the PC where the web werver's at only has the .Net framework and
Oracle8i installed.

John

Nov 13 '05 #1

Subscribe Post Reply

2631

Nicholas Paldino [.NET/C# MVP]

John,

I don't know much about oracle, but I think that there is a managed
provider or an Ole-Db provider that you can use to get data. If this is the
case, then why don't you just use the classes in the System.Data.OleDb
namespace or other Oracle-specific classes for your data access?

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- ni**************@exisconsulting.com

"John" <NA> wrote in message news:%2****************@TK2MSFTNGP11.phx.gbl...

Does anyone have an example of how to connect to an Oracle 8i DB and run a
simple select through ODBC? What DLLs should I need?
Assume that the PC where the web werver's at only has the .Net framework and Oracle8i installed.

John

Nov 13 '05 #2

Similar topics

Connecting Oracle8i to Python

by: the_rev_dharma_roadkill | last post by:

Hello, I'm a newbie to Python. In order to get much use out of it at my site, I must be able to connect it to Oracle8i databases. I'm running Python 2.2.2 on Tru64 (osf1 V5.1a). First...

Python

Oracle8i Client 8.1.7 Installation

by: Stephane VUILLIN | last post by:

Hi, I read a lot of threads about Oracle8i Client 8.1.7 installation. I did not succeed to install this product on a Pentium 4 Windows NT workstation. I downloaded the patch number 1507768 from...

Oracle Database

Handle count leak when connecting to Oracle via ODBC on Windows

by: Kong Li | last post by:

Follow up to this thread, the latest Oracle 9i release 2 patchset (9.2.0.5) fixed the handle count leak problem. The problem is in Oracle client component. Thanks. Kong ----- From: Kong...

Oracle Database

Connecting to SQL Server from ASP

by: nzanella | last post by:

Hello, I have MS SQL Server running on a server computer. I am trying to connect to it via ASP from a .asp file created in a virtual directory. I am using IIS as the web server. I am connecting...

Microsoft SQL Server

Access97 to Oracle8i odbc-problem (SQLSetConnectAttr failed)

by: TheAd01 | last post by:

In an Access97 application I fetch data from an Oracle database via a linked table (via Odbc/sqlnet). The Oracle database now upgrades from 7.3 to 8.0. The Oracle odbc driver I use (2.0.3.1,...

Microsoft Access / VBA

connecting to access db

by: Kavvy | last post by:

I'm working on a Win app and in the Data tab there are only classes for OleDB and Sql. I create an OleDB (Using the Microsoft OLE DB Provider for ODBC) connection to my Access DB, but it throws...

C# / C Sharp

Connecting to MySQL

by: Jeremy Dillinger | last post by:

I am trying to design a program that will use data from a MySQL database. Currently all the data is being used with PHP scripts from a website. I am also trying to build a software solution that...

Visual Basic .NET

connecting to mysql using asp.net - c#

by: Paradox Synthesist | last post by:

hi, i am a newbie to asp.net and have started learning mainly from websites. i have a question which IS very silly and trivial. ...

ASP.NET

Connecting to SAGE

by: franc sutherland | last post by:

Hi, I am trying to build a database in Access 2003 which can connect to information in a SAGE system. Should I use ODBC, and if so, which driver is required? Is there another way of...

Microsoft Access / VBA

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

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

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

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

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++