Deploying ESS

[Cath D]

Hi,

Anyone out there with a bit of ESS experience???

I've developed a FileMaker solution which predominated uses ESS to connect to MySQL.

Filemaker Server 9.02v

Mac deployment

MySQL

Actual Technologies Open Source ODBC driver.

In our development environment I have created a system DSN specific to the development SQL data source.

While on the live server a system DSN specific to the live SQL data source has been set up in parallel. This DSN has exactly the same details apart from the IP number of the data source.

Deploying the solution has resulted in a major issue. Even though the DSN is named correctly, all tables in the relationship graph referring to the SQL source are missing.

I can reselect the underlying table for each TO, but then all references to any field in the table (Scripts, Fields, Relationship key fields etc) point to incorrect fields.

Any help would be appreciated.

Cheers

Cath

[Cath D]

Hi thought, I'd post my solution....

Turns out the SQL Database name was different.

So the DSN must depend on the database name and table name being identical, if you wish to transfer between servers etc. Table name I can understand but since the database name is specified in the DSN this seems a little like overkill to me. Maybe someone can enlighten me?

Cheers

Cath

Edited January 24, 2008 by Guest