peterk

Thanks for your answer. I'll follow the link as you suggest. Peter

Hi, How can I enable logging to generate some raw access logs to test log-file analysis software ? Thanks Peter

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

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.

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

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 with Server 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.org Port 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

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

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