Connecting MapInfo to Oracle (Non-Spatial) ODBC/TNS Issue?

123 views

Skip to first unread message

Neal Kemp

unread,

Jul 12, 2013, 9:58:11 AM7/12/13

to mapi...@googlegroups.com

Hi All,

I am having some difficulty connecting my MapInfo to a remote Oracle server and was hoping someone might be able to assist... details below:

MapInfo v12 release build 16 (trial version)

Oracle server (not sure about versions, I can find out if important - I am using sql developer 3.2.09 but don't think that is of any import!)

On my machine I have set up:

TNSNAMES.ORA containing

DATALAB1 =
(DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = xxx.xxx.xxx.xxx)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SERVICE_NAME = DATALAB1 )
    )
)

and TNS_ADMIN env variable pointing to the path containing this file.

I have added and populated the ORACLE_HOME env variable and added the path of oci.dll to the PATH env variable.

I had to add the Oracle ODBC drivers to my machine, but these are now set up i.e. Oracle in SQLDeveloper now comes up as an option when setting up an ODBC connection and points to SQORA32.DLL.

In SQL developer, I can set up a TNS type connection, the server "DATALAB1" appears under Network Alias and I can connect with my usr/pwd.

In MapInfo I try File>Open DBMS Connection... then ODBC - OK, New DSN - create a DSN file for the connection with the above specified Oracle ODBC driver.

I then get prompted for the Service name usr and pwd so I enter "DATALAB1" and my usr/pwd.

However when I try to connect with MapInfo, I get the error:

"ODBC Error: ODBC RC=-1, ODBC SQLState=08004, DBMS RC=12154, DBMS Msg=[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified."

So it seems that DATALAB1 isn't being resolved - but it appears and works under TNS in SQL Developer. I'm stumped having spent quite a while just getting this far, so any help would be much appreciated!