I tried Ed Leafe example connection to "dabodev.com",
Database="webtest" and it works fine I can keep the connection for as
long as I want. My hosting service support have not solved the problem
that I have when I connect to my database. I ran the following Python code:
import dabo
import time
conn = dabo.db.dConnection(Host="mysql.netfirms.com", Database="d60220026",
User="u70234286", PlainTextPassword="ilovemus", DbType="MySQL")
cursor = conn.getDaboCursor()
time.sleep(11)
print cursor.execute("select count(*) as usercount from users")
print cursor.getDataSet()
If I make the sleep time before the cursor.execute 9 seconds of less
then the entire script runs. If I make it 11 seconds or larger then the
cursor.execute command give the error "MySQL server has gone away".
Perhaps someone could try the above to confirm that it has nothing to do
with my computer or firewall.
I noted that after I get the error that I can issue the cursor =
conn.getDaboCursor() again an not get an error, but then trying the
cursor.execute command again still gives the error message.
Dave
©2007 Dave Stredulinsky |
