Jump to content

Does FM Close SQL connections?


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

Recommended Posts

Hi guys,

Since my remote mySQL server blocked my IP (too many errors from my IP?) that got me thinking... Do I need to manually close out my mySQL connections after my queries?

I tried "custom SQL text" in my script and I put "CLOSE ALL" which just returned an error when the script ran.

You would think the folks that developed FM would be smart enough to close the mySQL connection for noobies like me, or does my ODBC driver handle that?

Thanks!

Link to comment
Share on other sites

If you are using ESS, FM will hold the connection open until you close the FM database that opened the MySQL connection. When the FM database is closed, FM will close the MySQL connection.

Jonathan Monroe

Actual Technologies - ODBC for Mac OS X

http://www.actualtechnologies.com

Link to comment
Share on other sites

This topic is 5470 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.