Skip to content

Latest commit

 

History

History
47 lines (26 loc) · 1.35 KB

databases.rst

File metadata and controls

47 lines (26 loc) · 1.35 KB
Raw

Database-specific options

This section collects a few details and gotchas related to specific database engines.

Microsoft SQL Server [mssql://]

Sample DSN:

mssql://<username>:<password>@<host>:<port>/<db>?driver=ODBC+Driver+17+for+SQL+Server

Multiple queries on a single connection

When defining multiple queries on the same connection with MSSQL, the Multiple Active Result Sets (MARS) feature should be enabled for query results to be reported correctly.

This can be done via the MARS_Connection parameter on the database DSN:

mssql://<username>:<password>@<host>:<port>/<db>?MARS_Connection=yes

Connection closed error during query execution

In some cases an error about "The cursor's connection has been closed" is returned when fetching query results.

If this happens, setting autocommit: false in database configuration should solve it.

Oracle [oracle://]

Sample DSN:

oracle://<username>:<password>@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <port>))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = <service>)))