JDBC Sharing on Filemaker Server Advanced

[IT Heroes]

Hi,

I couldn't find a JDBC forum sorry, so I am posting here. Please point me in the right direction if there is a better location.

I have several databases on fm server. I want to access them via JDBC. I created a single database with references to the other tables as stated in the fm10 jdbc guide.

"If your FileMaker database solution uses many FileMaker database files, create an additional database file that contains all the necessary external data source references, table occurrences, and relationships for your solution. Then define this additional database file as your data source in the JDBC URL. All of the FileMaker database files must be on the same computer."

I can connect and query tables that are in the file I set up, but when trying to access a referenced table it just tells me "Table Not Found"

Am I doing something wrong? It doesn't have any more information about this in the guide.

Thanks, Ryan

[IdealData]

Each file in the system must also be "publishable" via JDBC - see the EXTENDED PRIVILEGES in each file and turn on the "fmxdbc" extension.

[IT Heroes]

Thanks, They had sharing enabled, but I needed to create the same user and password in each database for it to work. I guess just like from within filemaker itself... makes sense when I think of it I guess the difference being the guest user wouldn't have had jdbc access.