Now, I'm trying to connect to External Oracle DB Server via ODBC within LAN network.

Everthing about setup is pretty much done, and I can see the full list of tables name when I try to add External database in relationship window.

I'm almost there!

 

I thought I'm fine so I w-clicked on the target table name but it shows just "ODBC error"

It doesn't even describe any detail about what kind of the error is.

 

WIth my SQL Plus, indeed I can connect to the Server.

 

Is there anything that I'm still missing???

or Do I have to do something with Server side??

As long as I can access to Server with SQL Plus, I thought I should succeed.

 

Does anybody know any about this case? Any idea?

 

This is my oracle setting

 

tnsnames.ora

 

TESTDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TESTDB)
    )
  )

Since you are on a 64 bit Windows and FMP is still a 32 bit application you need to use the 32-bit ODBC Control Panel to set up the Oracle DSN

My guess is that "SI Object browser 9" is a 64-bit application and thus can work with the ODBC DSN you've set up in the regular (64-bit) ODBC control panel.

Since you are on a 64 bit Windows and FMP is still a 32 bit application you need to use the 32-bit ODBC Control Panel to set up the Oracle DSN

My guess is that "SI Object browser 9" is a 64-bit application and thus can work with the ODBC DSN you've set up in the regular (64-bit) ODBC control panel.

 

Thanks so much. You are right! I could access to ODBC by setting up 32-bit ODBC control panel!

I didn't know that there are actually two control panels for both 32bit and 64bit.

Thanks for an answer

I'm also trying something similar....

 

What did you have to install on Windows to get the ODBC connectivity to Oracle?? I'm lost at this point....