Connecting and Editng Info On sql Sever

[dauber]

Sorry. Ignore the above. I had someone translate your post to me. I created the System DSN on the server not on my PC.

It helps to read and understand what someone is telling you.

Thanks for the help. Will continue working with this connection now.

[shawnblc]

....

But I do have a question, can I allow access from all hosts with just "%"?
It seems it would make remote access security redundant but then how do you determine who your users hosts are? Before they try to login?

Simon

Yes, you're correct if using cPanel you'd allow %, which would then allow remote access to all of your databases and tables. Unfortunately, in the cCpanel control panel there's no way to limit it to specific databases or tables.