Forums

Using pyodbc with sqlite

Hi all,

I'm looking to connect to a variety of DBs (SQL Server, Postgres, SQLite) and am hoping to use the same module for all (pyodbc). Has anyone successfully done this with sqlite on PythonAnywhere? I'm struggling to find any examples besides ms sql: https://help.pythonanywhere.com/pages/MSSQLServer

FWIW when I run pyodbc.drivers() I don't see any by default.

Beloved premium user grahams | 1 post | Aug. 10, 2022, 1:45 a.m. | permalink

It looks like there is an odbc wrapper for sqlite here: http://www.ch-werner.de/sqliteodbc/

Staff glenn | 9718 posts | PythonAnywhere staff | Aug. 10, 2022, 10:39 a.m. | permalink