For some reason, I can access my sql server through phpMyAdmin, ssh, and php, but I can’t get a remote connection from my computer. I’ve tried Excel 2003/2007. I’ve tried writing a C# script to connect. I’ve tried connecting from work as well as home. I don’t think it’s a firewall issue. Under my account in the control panel I set it to allow all IPs (%.%.%.%). Is there a simple setting I’m missing? I can’t imagine what I’m doing wrong. Thanks for your help.
Here is my C# code snippet:
static void Main(string args)
SqlConnection myConnection = new SqlConnection(“user id=ubooks;” +
“password=*******; server=mysql.ubooks.net;” +
"database=quotecache; " +
catch (Exception e)