Kli

It looks like Stevie has been down since yesterday (31-Jan) -- according to the news form, Stevie was back up on the 30th, but maybe it went down again? [i cannot log onto my web site / cPanel] Any idea when it is expected to be back up again?

I got a different error today when logging on to my web site: But the error log on the Control Panel contains only one line that says that it couldn't find a 500.shtml file! Any idea when the server problems are going to be fixed?

Any idea how long it will take? Could you please post a reply in this thread when the problem has been fixed? Thanks!

Sorry for the late reply (I'm over in Europe). Yes, I'm still getting this error periodically (5-Dec 09:35 GMT). Sometimes, when I'm using phpMyAdmin, I also sometimes get "#1045 - Access denied for user 'root'@'localhost' (using password: NO)". It looks like that mysql is still not stable?

Yes, I'm on Stevie -- thanks for your fast response!

There was a bug in my PHP software where it was not always closing a mysql connection. I have fixed this bug, but I still get errors accessing the mysql database from php: PHP Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home1/HelioUserName/public_html/db.php on line 24 Is there any way I can reset the error (or restart my web site or restart my database) to avoid getting this error?

All of the following connection strings give the same error "odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect": $conn = odbc_connect("Driver={MySQL ODBC 5.1.8 Driver};Server=localhost;Database=myUserName_myDBName;User=myDBUsername;Password=myDBPassword;Option =3;", "myDBUsername", "myDBPassword"); $conn = odbc_connect("DRIVER={MySQL ODBC 5.1.8 Driver};Server=localhost;Database=myUserName_myDBName;User=myDBUsername;Password=myDBPassword;Option =3;", "myDBUsername", "myDBPassword"); $conn = odbc_connect("Driver={MySQL Driver};Server=localhost;Database=myUserName_myDBName;User=myDBUsername;Password=myDBPassword;Option =3;", "myDBUsername", "myDBPassword"); $conn = odbc_connect("Driver={MySQL ODBC 5.1.8 Driver};CommLinks=tcpip(Host=localhost);DatabaseName=myUserName_myDBName;uid=myDBUsername;pwd=myDBPa ssword", "myDBUsername", "myDBPassword"); Do I need to change anything else in my connection string(s)?

Sorry, but neither of the four connections in my initial posting work, I still get error odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in scriptname.php on line nn mysql_connect() and mysql_select_db() using the same dbname/username/password works ok. Could it be that I have to use a different (variant of) connection string?

I'm on Stevie (http://stevie.heliohost.org). Thanks!

Geoff, thanks for escalating the request -- this PHP web-site is simple and straight forward, I just need it to be DB-agnostic (it just does a couple of SELECTs and INSERTs), a database abstraction layer would be overkill... Edward

I'd like to keep my PHP code database-agnostic -- I'm tring to deploy my code in different hosting sites (I do just a SELECT and a few APPENDs in my code) so I thought that odbc_connect() was a good option -- do you have a ODBC connection string that works on a MySql/SqlLite databse on Heliohost? Thanks Edward Clements

I am trying to connect to a MySql database at heliohost using PHP. There was a post "MySql ODBC Driver" from August 2008 (http://www.helionet.org/index/index.php?showtopic=3471&hl=odbc) with a reply from djbob (http://www.helionet.org/index/index.php?showtopic=3471&pid=38289&mode=threaded&start=#entry38289), but it doesn't seem to work now! Here are the connection strings I have tried: $conn = odbc_connect("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myUserName_myDBName;User=myDBUsername;Password=myDBPassword;Option =3;", "myDBUsername", "myDBPassword"); $conn = odbc_connect("DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=myUserName_myDBName;User=myDBUsername;Password=myDBPassword;Option =3;", "myDBUsername", "myDBPassword"); $conn = odbc_connect("Driver={MySQL Driver};Server=localhost;Database=myUserName_myDBName;User=myDBUsername;Password=myDBPassword;Option =3;", "myDBUsername", "myDBPassword"); $conn = odbc_connect("Driver={MySQL ODBC 3.51 Driver};CommLinks=tcpip(Host=localhost);DatabaseName=myUserName_myDBName;uid=myDBUsername;pwd=myDBPa ssword", "myDBUsername", "myDBPassword"); I always get error "odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect". Has the ODBC driver changed since August 2008? Please Help!