Did you copy the Data.fs file to the new machine or export it. I have noticed that you need to refresh the db connection when doing this. HTH Phil phil@philh.org ----- Original Message ----- From: Jim Sanford <jsanford@atinucleus.com> To: <zope@zope.org> Sent: Wednesday, September 01, 1999 4:29 PM Subject: [Zope] sql.error with ODBC on IIS 4.0
Have been setting up and testing a project on a Win 95 machine using Zope's built in server. (Zope version 1.10.3). Have built several queries which have been working fine.
Since the bosses liked our prototype it is now on fron burner. Have installed Zope on NT 4.0 machine with IIS 4.0 as the server.
Can get to the management screen but when I try to test my SQL methods all I get is a generic sql.error (traceback is below)
The ODBC connectors connect and disconnect fine. Even a simple "select * from names where id = 27000" gets the sql.error.
Can anyone help?
Traceback
<html> <head> <title>sql.error</title> </head> <body> Sorry, an error occurred.<p> <!-- Traceback (innermost last): File C:\InetPub\wwwroot\ATIAnywhere\lib\python\ZPublisher\Publish.py, line 877, in publish_module File C:\InetPub\wwwroot\ATIAnywhere\lib\python\ZPublisher\Publish.py, line 590, in publish (Info: /Query/ContactAll/manage_test) File C:\InetPub\wwwroot\ATIAnywhere\lib\python\Shared\DC\ZRDB\DA.py, line 305, in manage_test (Object: CopySource) File C:\InetPub\wwwroot\ATIAnywhere\lib\python\Shared\DC\ZRDB\DA.py, line 284, in manage_test (Object: CopySource) File C:\InetPub\wwwroot\ATIAnywhere\lib\python\Shared\DC\ZRDB\DA.py, line 384, in __call__ (Object: CopySource) File C:\InetPub\wwwroot\ATIAnywhere\lib\python\DocumentTemplate\DT_String.py, line 513, in __call__ (Object: <string>) File C:\InetPub\wwwroot\ATIAnywhere\lib\python\DocumentTemplate\DT_In.py, line 626, in renderwob (Object: Query.UserSettings()) File C:\InetPub\wwwroot\ATIAnywhere\lib\python\DocumentTemplate\DT_Util.py, line 266, in eval (Object: Query.UserSettings()) File <string>, line 0, in ? File C:\InetPub\wwwroot\ATIAnywhere\lib\python\Shared\DC\ZRDB\DA.py, line 390, in __call__ (Object: CopySource) File C:\InetPub\wwwroot\ATIAnywhere\lib\python\Products\ZODBCDA\db.py, line 197, in query sql.error: Sorry, an error occured
--> </body> </html>
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce
For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )