How to connect FileMaker12 on 64bit windows7 with Oracle server via ODBC?

[megalomania]

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)
    )
  )

[Wim Decorte]

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.

[megalomania]

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

[BrammersUK]

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....