[Zope] sql.error with ODBC on IIS 4.0

Phil Harris phil@philh.org
Wed, 1 Sep 1999 16:36:21 +0100


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: &lt;string&gt;)
>   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 &lt;string&gt;, 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 )