Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 3970 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

DurX58G.jpg

 

Any tips would be great.

 

Thanks

 

  • 5 months later...
Posted

 

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.

This topic is 3970 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.