Re: MS-Access & Oracle on a Unix Box

Steve E. Frazier (sfrazier_at_infinet.com) wrote:
: Can someone tell me if it is possible to run MS-Access on a Novell server
: and have it
: access Oracle databases off of a Unix box? Would the Novell server have
: to be running DOS Oracle in order to do so? If this is possible, how
: would it work, obviously via TCP-IP, correct?

Whatcha need to do:

1. Install SQL*Net TCP/IP for Windows on your PC
2. Install the Oracle ODBC driver for Windows
3. Print the README file on the ODBC disk and reinstall everything
4. Make sure you make the changes to your AUTOEXEC.BAT and copy the files.
5. Configure the ODBC driver to point to your database. Remember, the only important piece of the configure is the SQL connect string (we use something like this: T:raven:db01
6. Run Access and Attach a Table. That should do it. If you get errors, look at the README file and double check everything.

Here's the settings that I remember (which should be all of them, but not guaranteed):

In your TCP/IP services file:
  make sure there is an entry like this: orasrv 1525/tcp

AUTOEXEC.BAT:
  make sure \ORAWIN\BIN is in your PATH
  SET CONFIG_FILES=C:\WINDOWS\ORACLE.INI   SET CONFIG= If you're using Oracle 7:
  COPY \ORAWIN\RDBMS70\*.MBS \ORAWIN\DBS   (they might be *.MSB .... I can't ever remember correctly)

In your TCP/IP hosts file:
  make sure your database server is there...makes your connect string much   easier to remember.

That answer your question?

--
Jeff Kopmanis       (Ann Arbor, Michigan)   |  email:  jeffk_at_msen.com
Organizer of the Linux Software Map (LSM)   |  phone: (313) 393-4784 (work)
"So shines a good deed in a weary world."  -Willy Wonka