Page 2 of 2

Re: Connecting and Editng Info On sql Sever

Posted: Wed Mar 19, 2014 7:25 pm
by 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.

Re: Connecting and Editng Info On sql Sever

Posted: Thu Mar 20, 2014 6:06 pm
by shawnblc
Simon wrote:....

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.