I am currently using helio to host my database as my other provider doesn't allow me to have remote connections. I require remote connections for my SQL database as i am currently working on a project. This project is a program. The program must be able to access the database and pull and submit values from my database. I am currently making the program in Microsoft Visual C# 2010 Express and i am having issues connecting to the database. here is my current code:
static void Main()
{
using (SqlConnection myConnection = new SqlConnection("user id=lachee_admin;" +
"password=SECRETWORDS;server=johnny.heliohost.org;" +
"Trusted_Connection=yes;" +
"database=lachee_BrutalGame; " +
"connection timeout=2"))
{
try
{
myConnection.Open();
}
catch
{
MessageBox.Show("Could Not Connect To Database", "Connection Error 001", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Lobby());
}
}
For some reason, it cannot connect to the database. It states (when not surrounded my try and catch): I am sure that i have allowed remote connection to my database because I have inputted the wildcard (%). Is there anyway to connect? Does helio even support external program connection?