Re: Windows NT ODBC question

Merrill Lynch wrote:

> How do I connect my Access client to an Oracle server running on a Sun
> Unix
> box?
>
> I would assume that I use the oracle odbc driver.
>
> 1. What is the version I should use? What is the path in oracle's ftp
> site?
> 2. Do I need sqlnet on the client? on the server?
> 3. What configuration is required on the server?
> 4. What configuration is required on the client?

Hi,

You will need SQL*Net on both the client and the server. If your client is running on Win95/NT, then you can use a 32-bit ODBC driver regardless of the version of your Access client. Be sure to install the 32-bit SQL*Net if the ODBC driver is 32-bit. For SQL*Net v1, ODBC is establish by specifying a host string in the form of t:<server name>:<db name> but in SQL*Net v2, you must have an alias defined for an Oracle server and the ODBC driver will use t:<alias name> as the host string to attempt a connection.
Of course, you must be able to ping <server name> from your client machine. If a name server does not exist on your network, add an entry to your hosts file.

I hope this helps.

Vance

Vance Pan                       Email: vypan_at_unixg.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