I am unable to connect to Oracle 9i using MR 3.5.  MR Throws "Database Connection Error: ORA-12154: TNS:could not resolve service name".

• The Oracle 9.x client is installed on my workstation
• A TNS Service Name has been created for the DB.
• The TNS Service Name responds to a Test in the Oracle Net manager
• The TNS Service Name responds to a tnsping
• An ODBC DSN (Both System DSN and File DSN) has been created on the TNS Service Name.
• The ODBC DSN test is successful using the Oracle ODBC Driver Configuration dialog

I have tried entering the service name directly into the "Server" line in the MR "Database Connection" dialoge for Oracle 9i.  I have also tried entering [servername]\[DBname] and [serverIP]\[DBname].  Each of these methods throws the same "could not resolve service name" error.

Any ideas?

Can you try: <machine_name>:<port>/<server_name>, for instance: localhost:1521/ora11g (where ora11g is a database on my computer..)?

---

ModelRight Evangelist

That produces "Database Connection Error: ORA-06401: NETCMN: invalid driver designator".

This error occurs with the simple machine name, the fully qualified machine name (with domain), and the IP address as the machine name.

Also, dropping oci.dll (from the MR download page) into the MR installation folder changes the errors to "Database Connection Error:" ... without any details.