[Zope] Zope with ZsapdbDA

Vitor Varalonga vpedrosa@ciberbit.pt
Tue, 03 Sep 2002 19:41:57 +0100


--------------F11162FAA5846A19FC9F1532
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

    Hi,


    I'm having with the DA for SAP DB (ZsapdbDA) and i was wondering
if someone could lean me an helping hand.
    When i try to create a connection I get an error page with the
following text:

Invalid connection string: tst@matrix test test

Traceback (innermost last):
  File C:\PROGRA~1\Zope2\lib\python\ZPublisher\Publish.py, line 150, in
publish_module
  File C:\PROGRA~1\Zope2\lib\python\ZPublisher\Publish.py, line 114, in
publish
  File C:\PROGRA~1\Zope2\lib\python\Zope\__init__.py, line 159, in
zpublisher_exception_hook
    (Object: Zope)
  File C:\PROGRA~1\Zope2\lib\python\ZPublisher\Publish.py, line 98, in
publish
  File C:\PROGRA~1\Zope2\lib\python\ZPublisher\mapply.py, line 88, in
mapply
    (Object: manage_addZsapdbConnection)
  File C:\PROGRA~1\Zope2\lib\python\ZPublisher\Publish.py, line 39, in
call_object
    (Object: manage_addZsapdbConnection)
  File C:\Program Files\Zope2\lib\python\Products\ZsapdbDA\DA.py, line
25, in
manage_addZsapdbConnection
    (Object: Zope)
  File C:\PROGRA~1\Zope2\lib\python\Shared\DC\ZRDB\Connection.py, line
60, in __init__
    (Object: sapdb_database_connection)
  File C:\PROGRA~1\Zope2\lib\python\Shared\DC\ZRDB\Connection.py, line
89, in edit
    (Object: sapdb_database_connection)
  File C:\PROGRA~1\Zope2\lib\python\Shared\DC\ZRDB\Connection.py, line
168, in connect
    (Object: sapdb_database_connection)
  File C:\Program Files\Zope2\lib\python\Products\ZsapdbDA\db.py, line
37, in __init__
  File C:\Program
Files\Zope2\lib\python\Products\ZsapdbDA\DCsapdb\sapdbapi.py, line 101,
in
__init__
BadRequest: (see above)


The parameters on the connection are correct since I've connected
successfully through SQL Studio.
Since this could mean my installation for the DA was not that correct,
I'll describe how I've done it.
First, I downloaded and copied the adapter to the products folder.
Then I've downloaded the python modules and copied the files to the
folder ZsapdbDA\DCsapdb\sapdb and I've also copied the file sapdbapi.py
to the folder ZsapdbDA\DCsapdb.

When I run Zope on the command line I get no error message concerning
this product, but when I try to create a connection, kaboom.
Any clues/suggestions?


thanks in advance,

Vitor Varalonga

PS: the python modules version I used is 7.3.00.25 for win32 and
    Python 2.1, but I also test with version 7.3.00.21a.


--------------F11162FAA5846A19FC9F1532
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<tt>&nbsp;&nbsp;&nbsp; Hi,</tt>
<br><tt></tt>&nbsp;<tt></tt>
<p><tt>&nbsp;&nbsp;&nbsp; I'm having with the DA for SAP DB (ZsapdbDA)
and i was wondering</tt>
<br><tt>if someone could lean me an helping hand.</tt>
<br><tt>&nbsp;&nbsp;&nbsp; When i try to create a connection I get an error
page with the</tt>
<br><tt>following text:</tt><tt></tt>
<p><tt>Invalid connection string: tst@matrix test test</tt><tt></tt>
<p><tt>Traceback (innermost last):</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\ZPublisher\Publish.py,
line 150, in publish_module</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\ZPublisher\Publish.py,
line 114, in publish</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\Zope\__init__.py, line
159, in zpublisher_exception_hook</tt>
<br><tt>&nbsp;&nbsp;&nbsp; (Object: Zope)</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\ZPublisher\Publish.py,
line 98, in publish</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\ZPublisher\mapply.py,
line 88, in mapply</tt>
<br><tt>&nbsp;&nbsp;&nbsp; (Object: manage_addZsapdbConnection)</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\ZPublisher\Publish.py,
line 39, in call_object</tt>
<br><tt>&nbsp;&nbsp;&nbsp; (Object: manage_addZsapdbConnection)</tt>
<br><tt>&nbsp; File C:\Program Files\Zope2\lib\python\Products\ZsapdbDA\DA.py,
line 25, in</tt>
<br><tt>manage_addZsapdbConnection</tt>
<br><tt>&nbsp;&nbsp;&nbsp; (Object: Zope)</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\Shared\DC\ZRDB\Connection.py,
line 60, in __init__</tt>
<br><tt>&nbsp;&nbsp;&nbsp; (Object: sapdb_database_connection)</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\Shared\DC\ZRDB\Connection.py,
line 89, in edit</tt>
<br><tt>&nbsp;&nbsp;&nbsp; (Object: sapdb_database_connection)</tt>
<br><tt>&nbsp; File C:\PROGRA~1\Zope2\lib\python\Shared\DC\ZRDB\Connection.py,
line 168, in connect</tt>
<br><tt>&nbsp;&nbsp;&nbsp; (Object: sapdb_database_connection)</tt>
<br><tt>&nbsp; File C:\Program Files\Zope2\lib\python\Products\ZsapdbDA\db.py,
line 37, in __init__</tt>
<br><tt>&nbsp; File C:\Program Files\Zope2\lib\python\Products\ZsapdbDA\DCsapdb\sapdbapi.py,
line 101, in</tt>
<br><tt>__init__</tt>
<br><tt>BadRequest: (see above)</tt>
<br><tt></tt>&nbsp;<tt></tt>
<p><tt>The parameters on the connection are correct since I've connected</tt>
<br><tt>successfully through SQL Studio.</tt>
<br><tt>Since this could mean my installation for the DA was not that correct,</tt>
<br><tt>I'll describe how I've done it.</tt>
<br><tt>First, I downloaded and copied the adapter to the products folder.</tt>
<br><tt>Then I've downloaded the python modules and copied the files to
the</tt>
<br><tt>folder ZsapdbDA\DCsapdb\sapdb and I've also copied the file sapdbapi.py</tt>
<br><tt>to the folder ZsapdbDA\DCsapdb.</tt><tt></tt>
<p><tt>When I run Zope on the command line I get no error message concerning</tt>
<br><tt>this product, but when I try to create a connection, kaboom.</tt>
<br><tt>Any clues/suggestions?</tt>
<br><tt></tt>&nbsp;<tt></tt>
<p><tt>thanks in advance,</tt><tt></tt>
<p><tt>Vitor Varalonga</tt><tt></tt>
<p><tt>PS: the python modules version I used is 7.3.00.25 for win32 and</tt>
<br><tt>&nbsp;&nbsp;&nbsp; Python 2.1, but I also test with version 7.3.00.21a.</tt>
<br><tt></tt>&nbsp;</html>

--------------F11162FAA5846A19FC9F1532--