Error connecting to DB2 with python and sqlalchemy - Connection info needed in SQLAlchemy format

Question

I'm trying to connect to an IBM DB2 database using SQLAlchemy connection format but it keeps failing to connect.

I am using these libraries:

!pip install sqlalchemy==1.3.9
!pip install ibm_db_sa
!pip install --force-reinstall ibm_db_sa ibm_db

Loading the connector:

%load_ext sql

My connection string:

%sql ibm_db_sa://jqg6xxxx:r9C98t4TY81xxxxx@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sdxxxxxtu0lqde00.databases.appdomain.cloud:32731/bludb?security=SSL

Error message:

Connection info needed in SQLAlchemy format, example:
           postgresql://username:password@hostname/dbname
           or an existing connection: dict_keys([])
'sqlalchemy.cimmutabledict.immutabledict' object does not support item deletion
Connection info needed in SQLAlchemy format, example:
           postgresql://username:password@hostname/dbname
           or an existing connection: dict_keys([])

I am actually using this format but it just won't work.

The README seems to suggest that your connection URL string should start with db2+ibm_db:// — Gord Thompson
– Gord Thompson, Commented Nov 6, 2021 at 20:57

mao · Accepted Answer · 2021-11-08 14:06:31Z

3

Your connection string seems malformed: instead of ending with /bludb?security=SSL as shown in your question, try instead using the ending below:

/bludb;security=SSL;

Notice the sem-colon prefix and suffix.

Works for me with SQLAlchemy 1.3.24 and ibm_db 3.1.0 and ibm_db_sa 0.3.7. Requires that all other parts of the connection string are correct of course.

Also: both the prefix ibm_db_sa://.... and db2+ibm_db:// work for me to Db2 on Cloud (lite).

answered Nov 8, 2021 at 14:06

mao

12.4k2 gold badges15 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Milovan Tomašević Over a year ago

Have you used db2 in flask for SQLALCHEMY_DATABASE_URI ?

Perry · Accepted Answer · 2022-04-29 21:55:10Z

0

The error stated the format is username:password@hostname/dbname. You will see in yours that you added the port number So the the the change will be jqg6xxxx:r9C98t4TY81xxxxx@fbd88901-ebdb-4a4f-a32e-9822b9fb237b.c1ogj3sdxxxxxtu0lqde00.databases.appdomain.cloud/bludb?security=SSL I had the same issue recently and it worked for me.

edited Apr 29, 2022 at 21:55

Perry

3,90326 gold badges40 silver badges51 bronze badges

answered Apr 28, 2022 at 20:02

Nkem

1

Collectives™ on Stack Overflow

Error connecting to DB2 with python and sqlalchemy - Connection info needed in SQLAlchemy format

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related