SAP DB and Python

[Daniel Dittmar]

Gandalf wrote:
>  >>> from sapdb import dbapi
>  >>> dbapi.connect
> <class sapdb.dbapi.Connection at 0x00951D20>
>  >>> conn = dbapi.connect('dba','dba','Demo')
>
> Traceback (most recent call last):
>   File "D:\Python\Projects\Test\test.py", line 2, in ?
>     conn = dbapi.connect('dba','dba','Demo')
>   File "D:\Python23\lib\sapdb\dbapi.py", line 102, in __init__
>     database, host, configString)
>   File "D:\Python23\lib\sapdb\dbapi.py", line 60, in wrapCall
>     raise ProgrammingError (err)
> sapdb.dbapi.ProgrammingError: sql.SQLError: [-8000] (at 1) Message not
> available

Username and password are case sensitive, where as other tools like dbmcli
map them to uppercase unless quoted. So conn =
dbapi.connect('DBA','DBA','Demo') should work

Daniel

--
Daniel Dittmar
SAP Labs Berlin
daniel.dittmar at sap.com