repointing ODBC causing a mess

[thedig]

I have Server 11 ADv. working fine via ODBC MySQL 5.1.

I need to point to another server with the same tables exactly and once I do that all the tables references are lost.

If I redefine them in the relations diagram to their new location weird things happen and I also lose all my additional calculation fields I defined in the Mysql tables (in FM).

Has anyone managed to repoint an ODBC without wrecking havoc on Filemaker?

Thanks.

p.s. I'm using the same ODBC DSN - just changed server/user/pw

[Jonathan Monroe]

I need to point to another server with the same tables exactly and once I do that all the tables references are lost.

Internally, FM stores the database name along with the table and column names. This so that you can include two tables with the same name from two different databases.

The implication of this is that you can change the server (by changing the IP address in your DSN), but the new server must have the same database name as the old server. If the database names are different (i.e. one is named "staging" and the other is named "production"), you will see exactly the problem you are describing.

Jonathan Monroe

Actual Technologies - ODBC for Mac OS X

http://www.actualtech.com

[thedig]

Thanks Jonathan.

I was afraid that that was the case.

Problem is I can't give the database the exact name as the hosting co. won't allow it.

So will need to figure something out...