Connecting to a remote database (MySQL) problem

[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

 

[Miha Abrahamsberg]

Any ideas?

Miha

 

[Stefan Hoffmann]

hi Miha,

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

Sorry, but you'd better ask the MySQL guys...

http://forums.mysql.com/


mfG
--> stefan <--