search

waliwali / ibm-db

Automatically exported from code.google.com/p/ibm-db
0 stars 0 forks source link

db2 connect license #3

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
connect to a db2 instance running on a os-400
>>> from sqlalchemy import *;
create_engine('ibm_db_sa://myuser:mypass@somehost:446/somedb').connect(

expected: 
<sqlalchemy.engine.base.Connection object at 0x830126c>

output:
sqlalchemy.exceptions.ProgrammingError: (ProgrammingError)
ibm_db_dbi::ProgrammingError: [IBM][CLI Driver] SQL8002N  An attempt to
connect to a host failed due to a missing DB2 Connect product or invalid
license.  SQLSTATE=42968 SQLCODE=-8002 None None

versions:
 * linux 2.6.22-14-server (ubuntu 7.10 gutsy)
 * ibm_db 0.2.5
 * ibm_db_sa 0.1.1
 * sqlalchemy 0.4.3
 * os-400 v5r3

I think a local db2 connect license is missing, but I'm not clear on what
license to get and if this will aleviate the problem.

Original issue reported on code.google.com by pyalot@gmail.com on 16 Feb 2008 at 3:32

GoogleCodeExporter commented 9 years ago 
There are 2 separate issues to be dealt with here:
 * currently, ibm_db and ibm_db_dbi are only ready, tested and supported on DB2 for
Linux, Unix and Windows (LUW) data servers. As the README mentions the other 
future
platforms in the works are DB2 on i5 (iSeries), DB2 on z/OS and the next to 
arrive,
Informix IDS (Cheetah).
 * once the Python driver (ibm_db), DB-DBI wrapper (ibm_db_dbi) and SA adapter
(ibm_db_sa) are enabled properly to work with DB2 on i5 (i.e. while most of the 
data
server support is common across platforms, some metadata APIs need adjusting), 
a DB2
Connect type license is required. For any client used, from the simplest (DS 
Driver
for ODBC and CLI) to the more complete DB2 ESE, the DB2 Connect license file 
needs to
be located (made available) into the license path. Once the license file is 
provided
in the client /license path, one is able to use the same connection string as 
the one
provided in your test.

I hope this clarifies, and we'll make sure to keep you posted on our progress 
with
i5, z/OS and Informix IDS support additions.

Thanks for your understanding,
Alex P

Original comment by apiti...@ca.ibm.com on 18 Feb 2008 at 1:57