A driver that allows applications to manipulate SQLite databases via ODBC.
A driver that allows applications to manipulate SQLite databases via ODBC.
For more information, see
Questions tagged [sqlite-odbc]
4 questions
14
votes
4 answers
Updating an SQLite database via an ODBC linked table in Access
I am having an issue with an SQLite database. I am using the SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ Installed the 64-bit version and created the ODBC with these settings:
I open my Access database and link to the datasource. I can…
Herrozerro
- 1,601
- 1
- 22
- 37
2
votes
1 answer
Reading Huge volume of data from Sqlite to SQL Server fails at pre-execute
I have a huge (26GB) sqlite database that I want to import to SQL Server with SSIS.
I have everything setup correctly. Some of the data flows are working correctly and importing the data.
Data flows are simple. They just consist of source and…
Can Vural
- 2,222
- 1
- 28
- 43
2
votes
1 answer
pyodbc connection to sqlite database
I have very simple python script in which I try to connect to sqlite database using pyodbc:
#!/usr/bin/env python
import sqlite3
import pyodbc
con_str = 'DRIVER={SQLITE3};DATABASE=%s' % ('/tmp/test.db')
db = pyodbc.connect(con_str)
When i…
Maciej Szymonowicz
- 603
- 1
- 6
- 18
0
votes
1 answer
Error when use json_extract() on sqliteodbc
I use sqliteodbc from http://www.ch-werner.de/sqliteodbc/
and this code in ms word
str_cnxn = "Driver={SQLite3 ODBC Driver};Database=" & db_path
Dim Cnxn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Cnxn.Open str_cnxn
rst.Open "Select…
hubaishan
- 51
- 1
- 1
- 6