Connecting to a remote database (MySQL) problem

  • Thread starter Thread starter Miha Abrahamsberg
  • Start date Start date
M

Miha Abrahamsberg

Hey!

I want to connect Access 2003 to a remote MySQL database using MyODBC
connector tool.

I have both MyODBC drivers (3.51 and 5.1) installed.

Using the 3.51 version I can use the initial statement when connecting to a
remote dabase:

"Set wait_timeout=3600"

Without this the connection keeps droping after just a couple of seconds of
inactivity. But using this statement everything works great.

The problem is I can not find this option (initial statement) for the 5.1
version of MyODBC. And I would really like to use the 5.1 version, because
3.51 version is producing some SLOVENIAN characters errors...

So any ideas where I can set the timeout option in 5.1 MyODBC connector??

Miha
 
Back
Top