Oracle ODBC - How To Connect MS Access to Oracle Servers

How To Connect MS Access to Oracle Servers

Q

How To Connect MS Access to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection

✍: FYIcenter.com

A

Once you got a DSN defined in the ODBC manager that connects to an Oracle server, you can connect a normal MS Access document to the Oracle server, and link an Access table to Oracle table. The tutorial below gives you a good example:

Start MS Access with a new database file.
Go to File menu.
Select Get External Data.
Select Import.... The Import dialog box shows up.
Select Files of type: ODBC Database(). The Select Data Source dialog box shows up.
Click the Machine Data Source tab. You should see the DSN name "FYI_DSN" you defined earlier.
Select "FYI_DSN".
Enter User Name: fyi.
Enter Password: retneciyf.

You should see the Oracle ODBC Driver Connect dialog box as shown in the picture below:
Import Oracle tables to MS Access

Click the OK button to continue. You should see a list of tables available for you to import from the Oracle server as shown in the picture below:
Importing Oracle tables via ODBC

2007-04-17, 4717👍, 0💬

How To Define a Data Source Name (DSN) in ODBC Manager
How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection DSN (Data Source Name) is an ODBC connection identifier for Windows applications. Here is how you can define a DSN on your Windows system: Go to Control Panel. Go to Administ... 2007-04-17, 6230👍, 0💬

How To Connect MS Access to Oracle Servers
How To Connect MS Access to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection Once you got a DSN defined in the ODBC manager that connects to an Oracle server, you can connect a normal MS Access document to the Oracle server, and link an Access table to Oracle tab... 2007-04-17, 4718👍, 0💬

How To Connect ASP Pages to Oracle Servers
How To Connect ASP Pages to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the co... 2007-04-17, 4586👍, 0💬

Java Bean Class with 100 Fields
How to write a bean class, when you have 100 fields and each have three sub fields. 2007-04-26, 4582👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.