Is it possible to use SQLite3 with Microsoft SQL Server in Python?

Question

I am trying to connect to a Microsoft SQL Server with the SQLite3 module.

Everything seems to be recognized, but for whatever reason it doesn't recognize my columns or tables.

import sqlite3
con = sqlite3.connect('V7.0.6_X2_857I.sql')
cur = con.cursor()
cur.execute("""SELECT * FROM TS857_5400""")
all = cur.fetchall()
print one

However, I am running into this error:

---------------------------------------------------------------------------
OperationalError                          Traceback (most recent call last)
<ipython-input-39-04a8789e04a7> in <module>()
      3 con = sqlite3.connect('V7.0.6_X2_857I.sql')
      4 cur = con.cursor()
----> 5 cur.execute("""SELECT * FROM TS857_5400""")
      6 all = cur.fetchall()
      7 print one

OperationalError: no such table: TS857_5400

I know for a fact that this table exists, so I am wondering if this is some issue with the declared connection string or a limitation of SQLite3 (with SQL Server).

Thank you in advance.

Martijn Pieters · Accepted Answer · 2014-03-04 17:32:38Z

5

SQLite is an entirely different database, see http://www.sqlite.org/; the sqlite3 module has nothing to do with Microsoft SQL Server, but everything with the embedded database instead.

In other words, you cannot connect to SQL Server using the sqlite3 module.

You'll need to install a 3rd-party library to connect. The Python Wiki lists several options, ranging from ODBC drivers to SQL Server dedicated connectors. Which one will work for you depends on your Python version and your current OS.

answered Mar 4, 2014 at 17:32

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

Comments

holdenweb · Accepted Answer · 2014-03-04 17:32:31Z

2

You will find that SQLite has created a file called 'V7.0.6_X2_857I.sql' that contains a newly-created database. The sqlite3 module deals ONLY with SQLite and cannot connect to any other database type. You don't see the table because you are working in an empty database that you just created.

Unfortunately my driver knowledge isn't up to date, but what you need is a DB API-compliant driver module for SQL Server.

answered Mar 4, 2014 at 17:32

holdenweb

37.8k7 gold badges62 silver badges80 bronze badges

Collectives™ on Stack Overflow

Is it possible to use SQLite3 with Microsoft SQL Server in Python?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related