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