Jdbc problem with Filemaker 8.5

[mwarren2]

I can establish a database connection nicely via JDBC to only one of my Filemaker tables. All other files, I have discovered, are only findable by JDBC if a relationship is established to that first table.

This is frustrating because I would like to have 2 separate databases.

The relationship to the first table can be completely spurious, using completely unrelated fields, and JDBC is happy. But this is a very untidy solution.

I can get a connection to this first file either declaring or not declaring the name of the file (called NuoviContratti incidentally), and jdbc only wants the username and password.

So what I am saying is this:

If I connect using the following url (no file specified) I get connected to a file called NuoviContratti.

jdbc:sequelink://localhost:2399;user=bloggs;password=whatever

I can also include the serverDatasource option like this:

jdbc:sequelink://localhost:2399;serverDataSource=NuoviContratti;user=bloggs;password=whatever

and obviously I get connected to that same file.

If however I change the serverDataSource option to any other of my files I get:

Message: [DataDirect][sequeLink JDBC Driver][sequeLink Server]The specified data source is not defined.

I can assure you that over the past three or four very frustrating days I have checked and quadruple checked all permissions, and that JDBC/ODBC is on for all files - all the obvious things - and they are all the same as for this NuoviContratti file.

The NuoviContratti file also happens to be the first file I ever created all those years ago, but I don't suppose that has anything to do with it.

Has anybody got any ideas about what can be done here?

[mwarren2]

Ok, I now seem to have got one stage further, but it's only a tiny bit better.

Now I can put any of my files in as the "serverDataSource" in the Url and I get a connection to the database. Fine so far.

jdbc:sequelink://localhost:2399;serverDataSource=AnyTable;user=bloggs ;password=whatever

But as soon as I try to get a ResultSet, any of the files that do not have a relationship with NuoviContratti get the message:

"Table not found", so it seems to me that I am still only getting an actual connection to NuoviContratti.

[mwarren2]

Well, for whoever wants to know the answer I completely reinstalled Filemaker and have to run it as an Administrator. At last I can access all tables, and using "sourceDatabase" I can also keep two databases separate.

But if I don't run it as Administrator the 2399 port just doesn't show.