I was testing out Gadfly 2.0b on my 486 server here <g>, and it seems that I can't get Gadfly to read an existing database. All that I did was copy the files for the database over from /usr/www/users/jsight/biddin/pyPit/programsdatabase to /home/jsight/Zope/var/gadfly/programsdatabase. I did a cd to the database's directory under Zope and opened up the Python interepreter and opened the database with "connection=gadfly.gadfly('.','pyProgramsDatabase')". This worked, so I got a cursor and did a "cursor.execute ('select * from pyLibraries')" and printed the results. All was fine up until this point. Then I used my browser to open the management screens for Zope, added a connection to "programsdatabase" and added a new SQL method with no arguments which consisted of "select * from pyLibraries". However, from here when I click add and test it tells me that there exists no relation pyLibraries! Could someone please explain to me why this might happen? Perhaps there is something that I am missing in regards to how to actually setup the database connectin? All of the status screens say that the connection is open, though. Here is the full output from the test: Z SQL Method at /pyPit / all_entries Error, exceptions.NameError: 'PYLIBRARIES' no such relation in DB SQL used: select * from pyLibraries Traceback (innermost last): File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/ZPublisher/Publish.py, line 256, in publish_module File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/ZPublisher/Publish.py, line 161, in publish File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/ZPublisher/mapply.py, line 154, in mapply (Object: manage_test) File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/ZPublisher/Publish.py, line 98, in call_object (Object: manage_test) File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py, line 310, in manage_test (Object: all_entries) File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py, line 291, in manage_test (Object: all_entries) File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py, line 395, in __call__ (Object: all_entries) File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Products/ZGadflyDA/db.py, line 175, in query File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/gadfly.py, line 339, in execute File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/sqlsem.py, line 2604, in relbind File /home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/gfdb0.py, line 305, in bindings NameError: (see above) -- --------------- Jesse D. Sightler http://www.biddin.com/pyPit/