Search the Community

I am new to web development and I am having some problems figuring out how to deploy databases to the heliohost servers. My account is on johnny as I am doing ASP.NET development. I am trying to either deploy a local database to my heliohost account, or start a remote connection to the heliohost database and work with that directly. I tried to create a connection to johnny in mySQL workbench, but have been having problems. I created a new server instance to johnny and that seems to have worked. Then I attempted to create a new DB connection. This seemed to work as well, but then I attempted to create a new model, created a single table as a test and tried to forward engineer this and export the table but keep getting errors: It successfully connects to the DDMS, but when it tried to Execute Forward Engineered Script I get an error: I was wondering if anyone has any idea what I might be missing or what I should try to get this to work? Just to update this, I realized that I had not associated the user with the tstewart_test database on heliohost, but after doing this and giving it full privileges it still did not work.

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?

Hi, I am new to Heliohost and I haven't had any luck publishing my ASP.NET 3.5 site. I was wondering what is the easiest way to do this? I have set up DAV to simply transfer files over, but if I just upload my files it always gives me back an error: Server Error in '/' Application Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off". The problem is, even if I edit my web.config file in order to view the actual error, it doesn't seem to register. It is as if there is already a root web.config file that is completely trumping anything I do! Can anyone give a newbie some tips on how to publish a simple website to Heliohost using Visual Studio 2010? Thanks in advance!!