Re: Access and Oracle Workgroup server 7.3

From: Vance Pan <g2l1_at_ugrad.cs.ubc.ca>
Date: 1997/02/22
Message-ID: <330F7664.5007@ugrad.cs.ubc.ca>#1/1

Sam Kumarsamy wrote:

>

> I want to access Oracle WGS 7.3 tables through MS Access(front end)
> and vice versa. I have 32 -bit ODBC driver. How do I go about it ?

Hi,

If you want to connect one client to one server, you can apply the 2-tier connection by installing the ODBC driver and the communication library (SQL*Net) on your client (assuming it is Access97). Then you should configure SQL*Net on your Oracle server to listen to this client. You have to make sure that you are using a 32-bit ODBC driver for a 32-bit client application; if the client application is 16-bit, the 32-bit ODBC driver won't work.

If you want to connect many clients to one server or clients to a few servers, you can apply the 3-tier connection by having a ODBC server in the middle. In this case you will have one universal ODBC driver on the client(s) and everything else on the ODBC server. The client ODBC driver is a part of the ODBC server in this case. This ODBC server will connect to the data sources so the ODBC drivers (for Oracle, Sybase, etc.) and the communication libraries (SQL*Net, Open Client, etc) will be installed on this server, similar to the 2-tier connection. Because you can install many different ODBC drivers on this server, the client component becomes "universal"; it can access different data sources simultaneously because the server can talk to different data sources. SimbaExpress uses this type of architecture for database connectivity.

I hope this will give you some ideas.

Vance

---

Vance Pan                     Email: g2l1_at_ugrad.cs.ubc.ca

Free version of SimbaExpress! Download it at... http://www.simbatech.com/express

Need to build ODBC drivers? Check out... http://www.simbatech.com/sdk

For other information, you can contact info_at_simbatech.com

---

--

Received on Sat Feb 22 1997 - 00:00:00 CST