Server Help

[Cyan~Fire]

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.
_________________
This help is informational only. No representation is made or warranty given as to its content. User assumes all risk of use. Cyan~Fire assumes no responsibility for any loss or delay resulting from such use.
Wise men STILL seek Him.

[Solo Ace]

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]

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]

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]

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

[Solo Ace]

Control Center > Query browser.

[Cyan~Fire]

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]

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."