Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #108152 > unrolled thread

No SQLite newsgroup, so I'll ask here about SQLite, python and MS Access

Back to article view | Back to comp.lang.python

Contents

  No SQLite newsgroup, so I'll ask here about SQLite, python and MS Access DFS <nospam@dfs.com> - 2016-05-04 18:46 -0400
    Re: No SQLite newsgroup, so I'll ask here about SQLite, python and MS Access Stephen Hansen <me+python@ixokai.io> - 2016-05-04 19:02 -0700
      Re: No SQLite newsgroup, so I'll ask here about SQLite, python and MS Access DFS <nospam@dfs.com> - 2016-05-05 00:59 -0400
    Re: No SQLite newsgroup, so I'll ask here about SQLite, python and MS Access Michael Selik <michael.selik@gmail.com> - 2016-05-05 02:12 +0000
    Re: No SQLite newsgroup, so I'll ask here about SQLite, python and MS Access cl@isbd.net - 2016-05-05 10:01 +0100

#108152 — No SQLite newsgroup, so I'll ask here about SQLite, python and MS Access

Both of the following python commands successfully create a SQLite3 
datafile which crashes Access 2003 immediately upon trying to open it 
(via an ODBC linked table).

import sqlite3
conn = sqlite3.connect("dfile.db")

import pyodbc	
conn = pyodbc.connect('Driver={SQLite3 ODBC Driver};Database=dfile.db')
	

The file is created, a table is added, I add rows to the table in code, 
etc., and it can be read by 'DB Browser for SQLite' so it's a valid 
SQLite3 database, but Access won't read it.  I can create and store a 
link to the table - using that ODBC driver - but as soon as I try to 
open it: "Microsoft Access has stopped working"


On the other hand, a SQLite3 file created in VBScript, using the same 
ODBC driver, /is/ readable with Access 2003:

Set conn = CreateObject("ADODB.Connection")
conn.Open "Driver={SQLite3 ODBC Driver};Database=dfile.db;"


python 2.7.11, pyodbc 3.0.6, ODBC driver, and Access 2003: all 32-bit
OS is Win8.1Pro 64-bit.


I can't find anything on the web.

Any ideas?

Thanks

[toc] | [next] | [standalone]

#108156

On Wed, May 4, 2016, at 03:46 PM, DFS wrote:
> I can't find anything on the web.

Have you tried: 
    http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
If you really must access it over a newsgroup, you can use the Gmane
mirror:
    http://gmane.org/info.php?group=gmane.comp.db.sqlite.general

> Any ideas?

Sorry, I don't use Access.

-- 
Stephen Hansen
  m e @ i x o k a i . i o

[toc] | [prev] | [next] | [standalone]

#108159

On 5/4/2016 10:02 PM, Stephen Hansen wrote:
> On Wed, May 4, 2016, at 03:46 PM, DFS wrote:
>> I can't find anything on the web.
>
> Have you tried:
>     http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> If you really must access it over a newsgroup, you can use the Gmane
> mirror:
>     http://gmane.org/info.php?group=gmane.comp.db.sqlite.general


Thanks


>> Any ideas?
>
> Sorry, I don't use Access.

[toc] | [prev] | [next] | [standalone]

#108157

On Wed, May 4, 2016, 6:51 PM DFS <nospam@dfs.com> wrote:

> Both of the following python commands successfully create a SQLite3
> datafile which crashes Access 2003 immediately upon trying to open it
> (via an ODBC linked table).
>

Have you tried using Access 2013?

On the other hand, a SQLite3 file created in VBScript, using the same
> ODBC driver, /is/ readable with Access 2003


Microsoft is pretty intense about backwards compatibility, sometimes even
staying compatibile with old bugs. Not saying that's the case here, but it
wouldn't surprise me.

>

[toc] | [prev] | [next] | [standalone]

#108169

There's a gmane 'newsgroup from a mailing list' for sqlite:-

    gmane.comp.db.sqlite.general

It's quite active and helpful too.   (Also 'announce' and others)

-- 
Chris Green
·

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web