peterk Posted October 26, 2011 Posted October 26, 2011 Hi, Is is possible to use this service to connect using a DSN with the MySQL ODBC driver ? This would allow a .Net or MS Access platform application to retrieve and update the database. For this to work, the application would need a server IP address, a user name and password. Any help here much appreciated. PeterK
Guest xaav Posted October 26, 2011 Posted October 26, 2011 If you're running a .NET application on Johnny, you will have to use the MySQL Connector/Net adapter to connect to MySQL. If you are using an application that runs on your computer, then you should be able to configure the connector yourself.
peterk Posted October 28, 2011 Author Posted October 28, 2011 If you're running a .NET application on Johnny, you will have to use the MySQL Connector/Net adapter to connect to MySQL. If you are using an application that runs on your computer, then you should be able to configure the connector yourself. Hi, Thanks for this. I'm currently signed up to Stevie and am dealing with an application running on my computer. I've connected to MySQL hosts before by creating a DSN quoting either an IP address or a DNS Name. Will this approach work for Stevie and if not, how do I connect to Johnny ? And where do I get the server IP address ? Thanks again Peter Kaye
Guest xaav Posted October 29, 2011 Posted October 29, 2011 First of all, you should be aware that .NET applications to not run on Stevie. You will only be able to run .NET applications on Johnny, where mono is installed. I've connected to MySQL hosts before by creating a DSN quoting either an IP address or a DNS Name. Will this approach work for Stevie and if not, how do I connect to Johnny ? And where do I get the server IP address ? The host you are looking for is stevie.heliohost.org. This approach will work as long as you are running on your application on your computer, but as mentioned before, you will need to switch to Johnny to deploy your application. Also, you will first need to enable remote MySQL access.
peterk Posted November 2, 2011 Author Posted November 2, 2011 Sorry but I am still having trouble. I've created a database on Stevie and a MySQL user and password. I have MySQL ODBC 5.1 successfully installed on a pc ( i.e I can connect to other MySQL DB's) I've set up a DSN withServer Name : helio.host.org (is this correct - before I've used IP address ??) User Name : The MySQL user name I've created Password : The MySQL password for this user But I get message - "cannot connect to server on helio.host.org." (10060) Please can you tell me what I'm going wrong. Thanks Peter I've spotted some possible sillies in my earlier post.. Server should perhaps be stevie.heliohost.orgPort should be 2082 - port used in the phmyadmin connection Now I get the message... Lost connection to MySQL server at 'reading initial communication packet' , System error:2 Although this looks more hopeful - something is obviously still wrong. Am I correct to use port 2082 ? Peter
Krydos Posted November 2, 2011 Posted November 2, 2011 Have you done this: http://wiki.helionet.org/Mysql#Connecting_Remotely Connecting Remotely Step 1: Login to your cpanel Go to your cpanel. Step 2: Click on remote Mysql Click remote MySQL Step 3: Adjust Settings Put a percent sign in the box and click submit. Step 4: Connect Use the host stevie.heliohost.orgAnd 2082 is the port for cPanel. MySQL is port 3306.
peterk Posted November 2, 2011 Author Posted November 2, 2011 Hi,I followed your suggestion - inserted % in the remote urls box - but the ODBC problem remains. I still get the System Error 2. Could this be a firewall issue at the server end - I worked with a MySQL db once where the firewall had to be opened for the IP address used in the ODBC connection. Has anyone successfully connected to stevie by ODBC ? Peter
Guest xaav Posted November 2, 2011 Posted November 2, 2011 Are you connecting from port 3306, as mentioned above?
peterk Posted November 3, 2011 Author Posted November 3, 2011 It is 2082, the port that phpMyAdmin uses, that seems to get me closest - its obviously seeing the DB and trying to connect. This is the port that gives Error2. With 3306, the normal ODBC MySQL port , I get the message that access is denied.... "Connection Failed [HY000][MySQL ODBC 5.1 Driver] Access denied for user peter606_rupert'@'nn.nn.nn.nn.dsl.pipex.com' ( using passwords :YES) where nn.nn.nn.nn = my client ip address Does this means that 3306 is firewall protected ? Hope this helps. Peter.
Guest xaav Posted November 3, 2011 Posted November 3, 2011 Try connecting with your cPanel username and password.
Krydos Posted November 3, 2011 Posted November 3, 2011 Try connecting with your cPanel username and password.While using port 3306.
peterk Posted November 4, 2011 Author Posted November 4, 2011 Thanks very much - this worked fine.Thanks to everyone who helped with this. Port 3306 and cpanel user name and password is the key ! Brilliant. Peter
Krydos Posted November 5, 2011 Posted November 5, 2011 Glad your problem got solved! Please spare a few minutes to take our brief survey: http://feedback.heliohost.org/ Your participation in this survey is greatly appreciated.
Recommended Posts