oconnor

Hi,

I want/need to be able to connect to a mySQL database hosted on my domain and be able to read and write to this using Excel. I have downloaded the mySQL ODBC driver but still cannot make the connection.

It seems that the security on the server or mySQL is preventing my from connecting. I am specifying the domain name, userid, password etc. but it just will not connect.

Has anyone managed to do this or got any ideas how I can get this working ?

thanks

Chris

pvera

My first guess is that Surpass is blocking external access to the MySQL server.

__________________
Pedro
Blog: http://veraperez.com
Reseller: http://veraperez.net
GPG/PGP Key: http://veraperez.com/public.asc

miakeru

Correct.

Oldswede

hi, look at your cpanel/mysql databases/ all the way down you´ll find:
Access Hosts:
if you own a static/permanent ip adr. you type in your ip adr. there
if not you can type in the % in there.
but think about security.

i due it for a long time cause i have a static ip adr. from my provider.
i due automatic database backups that way from my home-pc.

greetz
os

oconnor

Oldswede - Thank you ! I'd looked at that a couple of times before and tried sticking in all sorts of things, but never % on it's own. I know it does say that, but for some bizarre reason I thought it meant % followed by something. I never thought it was a wildcard. Anyway, thanks to you it now works. Now just have PHP to learn !

Chris

sam

oconnor - keep in mind that we don't support the remote access of mysql server - and recommened against it.

also - using the wildcard is NOT a good idea. while it will work - consider the consequences.

a much safer method is to run mysql elsewhere and do mysql dumps of your surpass content.

vbmenu_register("postmenu_69576", true);

tebuco

Hi,

Can anyone point me to any threads about local-desktop-client alternatives to phpmyadmin to manage my surpass mysql database?

I would like to use Microsoft Access as a front end to the mysql database on surpass because of its query, forms, and reporting features. Using the ODBC driver works quite nicely, but I get frequent timeouts (MySQL server has gone away; error 2006). I tried to adjust the MS Access Options under Tools, Options, Advanced, but I don't really understand them. Reading the forums, it looks like such a setup is not really supported or at least not recommended for some reason (or wasn't in 2004 anyway).

Using OpenOffice Base would work fine, too. But I get the same timeout problem.

MySQL Query Browser seems to hold, or at least reset, the connection fine, but is limited compared to Base and Access.

Thanks,
Pete

demontech

You have a few tools here that may help.
http://www.mysql.com/products/tools/

__________________
Sincerely,
Demon

High Quality Hosting Service Provided By
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

tebuco

Thanks, Demon. Yeah, I guess I just have to buckle down and learn how to quickly build the various joins. Your link led me to:
http://www.mysql.com/products/tools/...d_queries.html
which has a nice video-like demon-stration.