Trouble Connecting MySQL to FM12 Win7x64 ODBC 32bit

[GisMo]

Using Win7x64 I've installed both 64bit and 32bit ODBC drivers, but from what I've been reading, must use 32bit drivers.

 

 

I've installed the MYSQL ODBC drivers to test the connection to the external database and it works fine. Also, I can use Import and select this DSN and it works fine as well.

 

Now to FileMaker DSN: 

 

Open 32bit ODBC Data Source Adminstrator

Goto System DSN Tab and add Filemaker ODBC

for host I use the server's IP(it's not local): xx.xx.xx.xx:3306 (port 3306 is used for MySQL access) I can type in the DB name(testing fails here as well)

 

Next:

Open Filemaker 

Open Local FM Solution

File->Manage->External Data Sources..add new DSN 

 

 

When I try to connect or add tables via the graph I get this error.

 

Any tips would be great.

 

Thanks

 

[Wim Decorte]

 

Now to FileMaker DSN: 

 

Open 32bit ODBC Data Source Adminstrator

Goto System DSN Tab and add Filemaker ODBC

for host I use the server's IP(it's not local): xx.xx.xx.xx:3306 (port 3306 is used for MySQL access) I can type in the DB name(testing fails here as well)

 

 

This is confusing.  You are trying to import FROM mySQL, right?

Then you do not need to set up anything using the FM ODBC drivers.  That is only for ODBC access to FM data

And if you did, FM only lists to port 2399.

 

The screenshot you have seems to indicate that you are trying to use the DSN that uses the FM ODBC drivers.  So basically you are asking FM to import from FM and that doesn't work that way.