mysql db connecten by internet

[knackje]

I've got a mysql database running by a webhosting company. Now i want to connect to it by a local Ms Excel file.

But is this possibele and how to do this?

I thought i could do this by a local odbc or sql driver. But i can't make it works. Anayone has some tips or have experience with this

tnx in advanced

 

[nobaloney]

I believe you have to allow in your MySQL file to allow the access from the specific IP# you're trying to attach from. I don't know if you can do it from a dynamic IP#, and I'm not an expert and don't know how to explain it further; perhaps someone else does.

I know it's doable because you can get a desktop client for MySQL; I've tried that and it just works.

You might want to ask on a MySQL forum.

Jeff