AnsweredAssumed Answered

sql developer

Question asked by larryw on May 29, 2016
Latest reply on May 30, 2016 by electon

I'm trying to connect to FM14 advanced via JDBC using Oracle Sql Developer. I'm running on OS X El Capitan.

 

The FM database, called ORNAMembershipV5, is running under FM14, the ODBC/JDBC drivers have been installed. JDBC is enabled, and the fmxdbc_listener is waiting patiently. Through Sql Developer I'm attempting to establish a connection using the jdbc URL

 

     jdbc:filemaker://10.0.1.6/ORNAMembershipV5

 

for which ORNAMembershipV5 is the name the FM Sharing form indicates, and on which "All Users" radio button is marked. The IP address indicated above the NAT IP address of the computer on which both the Filemaker application and database file, and the Sql Developer application is running.

 

I've attempted to connect and test the connection from Sql Developer, using the FM user 'Admin', which has no password, and user 'wkr' which does have a password and has read access, and has authority to connect via ODBC/JDBC. Sql Developer notes failure to make connection to FM and this FM application.

 

Please suggest what I need to do to successfully connect.

Outcomes