Here is a perplexing problem I am experiencing. First, I was able to compile the MySQL database adapter (MySQLdb) for WIN2000 and connect successfully to a database I set up on Windows. I set up a ZSQL method to return rows from the database. Then I set up a DTML method to iterate over the rows and fill a html page using "dtml-in" to receive records from the ZSQL method: ...snip...snip... <dtml-in sqlQuery> <dtml-var last-name> <dtml-var first-name> </dtml-in> ...snip...snip.... This worked fine. Next, I was able to connect with a MicroSoft Access database using an ODBC method. Then I did the same as before. Create a ZSQL method (e.g. sqlQuery), then iterate over these rows with a "dtml-in" tag, filling an html page. Now here's my problem. When I set up a MySQL ODBC connection. The ZSQL method by itself returns rows from the database just fine. However when I access the index_html page that contains the "dtml-in" tags.....it causes a prompt to reauthenticate to Zope (username and password). No known username and password will work. I set all my MySQL permissions properly as far as I know. I've scoured the archvies but have found nothing. I need some leads as to what to try. Thanks in advance. Rich Herrington University of North Texas Academic Computing Services Research and Statistical Support Voice: 940 565 2140 Email: [EMAIL PROTECTED] "You live and learn. At any rate, you live." -- Douglas Adams "Where is the knowledge that is lost in information? Where is the wisdom that is lost in knowledge?" T.S. Eliot "Whenever I have a little money I buy books; if there's any left over, I buy food and clothes." Erasmus "It is impossible for a man to learn what he thinks he already knows." Epictetus (50-138 A.D.) "True wisdom is less presuming than folly. The wise man doubteth often, and changeth his mind; the fool is obstinate, and doubteth not; he knoweth all things but his own ignorance." Akhenaton? (c. B.C. 1375) "Happiness is the absence of the striving for happiness." Chuang-tzu (fl. B.C. 350) _______________________________________________ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )