I've setup MyODBC (Win98) so I can access a MySQL db from Excel. It works
fine, except that everytime I refresh the data, I get the MyODBC prompt,
even when I select the option "Don't Prompt on Connect". This is kind of
anoying, as I need to execute well over 700 queries.
Anybody have any ideas?
What's the priviledge for the username?
I think the privilidege has to explicitly say that it can connect from the
IP address of the server machine, not just localhost
JuanE
Hello,
I have a MySQL account that only accepts connections from localhost for
security reasons. I wish to use