On Dec 26, 2007, at 5:34 PM, Dave Stredulinsky wrote:
> 1. In importing dabo in the IDLE shell , I get the following
> error (it
> works fine from the Command Prompt) :
I don't use IDLE, so I haven't tested it under that tool. From the
error traceback, and the fact that it is working correctly otherwise,
it seems that IDLE is interfering with the pathing so that Dabo can't
find the localization files. Can you create a ticket on our bug
tracking system so that I don't forget to look into this? The URL is:
http://trac.dabodev.com/newticket
> 2. In using the App Wizard. or generated code, I loose connection
> to an
> online database in a matter of seconds so that if I wait too long to
> connect or try to connect again I get the error 'MySQL server have
> gone
> away'.
That sounds like a problem with your server, since the Dabo
connection in an AppWizard doesn't close until the app exits. Try
this from the command line:
>>> import dabo
>>> conn = dabo.db.dConnection(Host="dabodev.com", Database="webtest",
User="webuser", PlainTextPassword="foxrocks",
DbType="MySQL")
>>> cursor = conn.getDaboCursor()
At this point, you should have a cursor that is connected to the
public test database on our server. You can execute commands such as:
>>> cursor.execute("select count(*) as zipcount from zipcodes")
1L
>>> cursor.getDataSet()
({'zipcount': 42899L},)
Now try the same thing again, except when you create the connection,
pass the host, user, password, etc., from your server instead of the
Dabo server info. Try running simple queries and see if you still get
the disconnection problem.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
