Server Help :: View topic - Connecting to MySQL with Access

Server Help

Trash Talk - Connecting to MySQL with Access

Cyan~Fire - Tue Nov 22, 2005 6:57 pm
Post subject: Connecting to MySQL with Access

I'd like to connect to the MySQL server on my webhost. I only have cPanel access, but I have added my IP to the "allowed hosts" list. I setup an ODBC TCP/IP connection (left port on default) but it gives a "General network error" when I try to connect. Suggestions?

Last time I just wrote a php script that output the data in an HTML table and then copied into Excel, which worked, but this would be much easier.

Solo Ace - Wed Nov 23, 2005 1:31 am
Post subject:

I suggest you capture the traffic to determine what's going wrong.

A "General network error" is a great description of the problem, yeah.

Cyan~Fire - Wed Nov 23, 2005 11:37 am
Post subject:

Ehhh, that's far too much work.

Basically I was wondering if anybody here had successfully done this before? I guess I'll have to capture the traffic myself if nobody has.

Mine GO BOOM - Wed Nov 23, 2005 1:10 pm
Post subject:

Try using telnet and see if that connects. That will tell you if the port is open or not. Next, try using a different MySQL application, such as their control center program (use an old version, search google).

i88gerbils - Wed Nov 23, 2005 4:24 pm
Post subject:

MySQL Query Browser works pretty well in Windows although their Linux version is fully of hidden dependencies.

Solo Ace - Wed Nov 23, 2005 4:39 pm
Post subject:

Control Center > Query browser.

Cyan~Fire - Thu Nov 24, 2005 12:33 am
Post subject:

Alright, I got it to connect with mysqlcc and I set up an ODBC source thing (apparently the default port in mysqlcc works), but now Access gives me a crap "User Cancelled" error when I try to connect. This is not a plea for help, just a status report, but any suggestions would still be appreciated.

Cyan~Fire - Thu Feb 02, 2006 9:21 pm
Post subject: solution

Just to let you guys know, it's a non-existent database name that gives that error. (I had a space in front.) Apparently that always gives "User cancelled."