from access to oracle - Microsoft Access / VBA

Miikka Hamalainen

Hi,

We have huge oracle database in my company.
I would like to make some queies using access. I've been trying to connect
access to this oracle db, but without any luck.
Do I need to have some oracle drivers?
We are using other program to get information from the db and we have
acquired drivers for that program.

Any help is appreciated.

Thanks,

Miipe

Nov 13 '05 #1

Subscribe Reply

1778

MGFoster

Miikka Hamalainen wrote:

Hi,

We have huge oracle database in my company.
I would like to make some queies using access. I've been trying to connect
access to this oracle db, but without any luck.
Do I need to have some oracle drivers?
We are using other program to get information from the db and we have
acquired drivers for that program.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes, you need the Oracle ODBC driver, or the Oracle OLEDB driver. The
ODBC driver should be in the Drivers tab of the ODBC Data Source
Administrator (Control Panel > Administrative Tools). Go to this WEB
site for ODBC connection strings:

http://www.connectionstrings.com/

Read the ADO documentation for the OLEDB connection strings.

Once you've set up a connection you can use SQL Pass Through (SPT)
queries, using Oracle's SQL syntax, to retrieve data. Read the Access
articles on SPT queries for more info.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQwOLFYechKq OuFEgEQJq6wCfes RE27RvGxIYsFHJu U8FUBIbnTgAoLuH
GrB/nWIKL0xKvpwF8wo nBKWL
=5mjM
-----END PGP SIGNATURE-----

Nov 13 '05 #2

Tim Marshall

Miikka Hamalainen wrote:

We have huge oracle database in my company.
I would like to make some queies using access. I've been trying to connect
access to this oracle db, but without any luck.
Do I need to have some oracle drivers?
We are using other program to get information from the db and we have
acquired drivers for that program.

Access is a truly wonderful reporting tool to use with Oracle. With
experience, you can also write extremely effective applications that
will also manipulate (ie inserts, updates, deletes, DDL) Oracle very well.

You need to use an ODBC driver and set up a sat source name or "DSN".
If you need help with this, write back - I have an old Powerpoint
presentation for the win98 environment (it's essentally the same for
winXP) I've sent to a lot of Oracle users in the past I can email you.

You have two choices for the ODBC driver. Access comes with a Microsoft
produced Oracle ODBC driver and your Oracle installation cd comes with a
driver.

I've always advised using the Oracle ODBC driver over the MS one but my
organization is still using Oracle 8i. Some of my colleagues who use
Access against Oracle elsewhere have found some difficulties with 10G
and it's ODBC driver - I forget exactly the complication. They found
the MS one worked around the problem.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Nov 13 '05 #3

Similar topics

3984

Problems querying oracle db from Access 2000

by: jhweb | last post by:

I am trying to query a table in oracle from Access 2000 using the following criteria. select * from table1 where DATE_RECEIVED between '1/jan/2003' and '30/jun/2003' I am using the Oracle odbc driver. Records should be returned but nothing.

Oracle Database

23459

Import table from Oracle to Access

by: Jon Ole Hedne | last post by:

My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary Access-tables. I have tried this: conn.Provider = "Microsoft.Jet.OLEDB.4.0" conn.ConnectionString = "data source=" & datafil & ";Jet OLEDB:Database Password=" conn.Open datafil

Microsoft Access / VBA

3536

Accessing data from an MS access db from an Oracle UNIX server

by: Andrea M. Segovia | last post by:

Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access databases who would like to share their data using this visualization tool but do not want to import their data into the Oracle server back-end.

Microsoft Access / VBA

17063

Oracle vs Access

by: Rosco | last post by:

Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the Ford Fairlane. I need this info to complete a school project. Thanks.

Microsoft Access / VBA

2715

Automatic update from Oracle db to access db

by: girlkordic | last post by:

I have a linked table from an Oracle database (that contains HR information for my company)in an Access database. The Oracle DB is updated on a daily basis. I would like one of my tables in Access to update automatically so when an employee is hired, my access table reflects that new employee that was added to the Oracle DB. I should say I have read-only access to the Oracle Db. Would I have to run an update query or can this be...

Microsoft Access / VBA

7081

Append query from Oracle Back-End

by: robboll | last post by:

When I try to use an append query from an oracle link it takes forever. I am exploring the idea of doing an append action using a pass-through query. If I have an Oracle ODBC connection to server OraTest. User: User1 Password: password and I am trying to append all records in table: tblTEST that are code: "abc"

Microsoft Access / VBA

4240

Convert MS Access DB (FE&BE) to Oracle

by: egoldthwait | last post by:

I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with this. Also - the citrix folks do not want us to keep the FE in Access as the queries and other activities consume a lot of power. The users will be in 3 different offices across the globe all accessing the 1 Oracle DB in Citrix. Does anyone have...

Microsoft Access / VBA

9769

Updating a table with specific info from another table

by: John T Ingato | last post by:

I have a contacts table with name address and such but are missing all phone numbers in the phone number fields. I have just received an updated customer list in Excel and have imported into a new table. Can I run a query that will take the phone number only from the new table and update the old tables phone number fields from empty to the proper information?

Microsoft Access / VBA

3456

Migrating Unicode data from MS Access to Oracle

by: shaguna.dhall | last post by:

I need to migrate Unicode data from MS Access to Oracle. Have tried the following: -Exported the Access tables to csv/txt, but these files were generated in ANSI encoding, and the Unicode data got converted to ASCII characters. -ODBC export directly to the Oracle tables doesn't work either. -However, when the table is exported to excel, Unicode encoding is retained.

Microsoft Access / VBA

9671

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10161

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

9035

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

7538

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

6777

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

5436

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5560

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

4112

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3720

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