[thelist] MySQL export for non-technical client

Joel Canfield joel at spinhead.com
Sun Oct 20 12:25:01 CDT 2002

[ Picked text/plain from multipart/alternative ]
> for non-technical client % % % do you have any more info on
> this solution?
> It's called MyODBC.  Type either that (or, hell,
> probably "MySQL Access ODBC", hint hint) into
> Google.

Yeah, that's how *I* found it, too ;)

John, any feedback on my follow-up post yesterday? I'm all installed and
seem to be configured, but not connecting.
Any chance you could save me some troubleshooting time? I keep getting the
error "Lost connection to MySQL server during query" I suspect it's an
authentication issue, but I can't see how to fix it.

Doin it manually, I first create the connection to the server with PuTTY on
port 22 (I note you specifically mention port 3306, which wouldn't be an SSH
connection, would it?) using the server username and password. Only then do
I enter the MySQL connection info (user/password) which is all the ODBC
driver contains.

I can't figure out how to perform the original connection before Access
tries to connect to MySQL.

Am I missing something obvious?


More information about the thelist mailing list