[AccessD] FW: Error Message while Connecting Access to Oracle

Rocky,

I passed your post (up to and including Martin's last post) along to a colleague who has some Oracle experience.  Here's his response:

<quote>

I would agree with what has been said.

I would install an Oracle Client and not use the MS version of the ODBC. Once the Client is installed it should come with SQL Plus that can be used to test connectivity.

The syntax of the tnsnames.ora file looks correct below.

MRDF =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522))
    )
    (CONNECT_DATA = (SID = MRDF))
  )

Although it has been some time since I used Oracle 8i, I do recall that I had an issue once that gave the same error and it was because I updated the wrong tnsnames.ora file. I recall that there were tnsnames.ora file under the install folder somewhere and another under the \NETWORK\Admin subfolder. I do not recall which one was the correct one.

Also, if it is a local install of Oracle on a MS Server then the Oracle Services may not be set to auto start.

<end quote>

Hope this may help.

Don McGillivray

This e-mail may contain Sprint Nextel Company proprietary information intended for the sole use of the recipient(s). Any use by others is prohibited. If you are not the intended recipient, please contact the sender and delete all copies of the message.