Workflow for an external database

[Gary Weisbrodt]

The instructions in Flash for connecting to an external database state:

Set up your data source; for example, in the ColdFusion environment, set up a ColdFusion DataSource component to connect to your data source.

How would this be acomplished for FM Pro 7?

[shilpa]

Have you installed the JDBC/ ODBC drivers for FMPro on your comp.. i think it is shipped along with your FM installation disk but you have to install it separately.. then create a user DSN adding the FM drivers for it. Then follow the steps given by Flash help.. I think that should work....

Good Luck.

[aaa]

Hi, guys! When i open my "Administrativ tools" on PC Windows, i see only ODBC source. What i must do to have JDBC/ODBC? I want to connect to FM from Java.

Edited December 7, 2005 by Guest

[MetaSys Software]

Administrative tools will only have ODBC there.. tyr with those drivers itself.. i think you will get through it as you can connect ODBC through JAVA..

[MetaSys Software]

Administrative tools will have only ODBC over there.. try using those drivers itself.. i think you should be able to get through as JAVA is capable of connecting through ODBC as well..

Good Luck!

[aaa]

Hi, MetaSys Software Pvt. Ltd. ! Thank you for you reply. I am glad that i can do it have only ODBC, but if you know, please tell me step by step what i must to do for read or write information from Java to (let say) Invoices FM file.

Thanks!

[MetaSys Software]

Hi aaa...

as you are a java programmer i guess u should be knowing the steps involved in jav.. but still i will try what i can.. just ignore if something is irrelevant.. as even i havent tried connecting to Fm via JAva.. all i know is as follows..

Step 1: Loading Drivers:

Class.ForName("DriverName");--- i guess Filemaker Pro is the driver name here.. or it should be dataDirect 32-bit SequeLink 5.4

Step 2: Making Connection:

Connection.con = DriverManager.getConnection("jdbc:odbc:);

Step 3: Prepare Statement

Statement stmt = con.CreateStatement();

Step 4: Prepare Resultset.

Resultset rs = smt.executeQuery("Query");

I hope this is helpful to you.. that is the only thing i am able to figure out.. tell me how it goes.