[Zope] Zope with ZsapdbDA

[Brad Clements]

Capitalize the name of the database and the userid ???

I had to do that for my Zope.

try

TST@matrix TEST test

where TST is the database name, and TEST is the userid.. test is the password. Not 
sure if that needs to be capitalized or not (my password is numbers)

On 3 Sep 2002 at 19:41, Vitor Varalonga wrote:

> 
>  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.
> 


Brad Clements,                bkc@murkworks.com   (315)268-1000
http://www.murkworks.com                          (315)268-9812 Fax
AOL-IM: BKClements