4

I've been working on a modification of the django-pyodbc package so that it could be used with MS Access.

I need this for a legacy database we are tied to at my organization, and have been doing a rather hacky job specific to my situation, but have also been making useful, generalizable progress in terms of adapting SQL syntax for MS Access.

My question is, is this a project that anyone else in the world is interested in? should I clean up my code and try to fully generalize it, or is everyone else in the world able to solve their MS Access problems by moving to SQL server?

James
  • 306
  • 3
  • 5
  • 1
    Perhaps setting up your Access (i.e., Jet/ACE) database as a linked server in SQL Server would help you avoid localizing for Jet/ACE? – David-W-Fenton Feb 05 '10 at 03:14
  • Yes, I think you will find people interested in this project. I have a specific instance in which I could use it myself. – Larry Lustig Mar 12 '10 at 21:10

1 Answers1

0

I would move the data to SQL Server if that is an option.

If moving the data is not an option and if my Django app is already connecting to SQL Server, I might just create a linked server on SQL Server and go through SQL Server instead.

cethegeek
  • 6,286
  • 35
  • 42
  • I mostly finished the implementation (introspection + admin system = working, test suite = unfinished), but I have two issues, limitations of the JET ODBC engine: 1. 127 column limit in a SELECT query in Jet 2. Performance = awful. From the link above: "Usage of such data are only limited by the limitations of the Access database. In MS SQL 2005 server the external data is accessed through the OLEDB interface, and the limitations are those imposed by this provider." Does anyone have info that might shed light on whether linking servers would provide a workaround for speed or column limit? – James Feb 12 '10 at 00:08
  • not sure why this got voted down. it seems like a practical solution, although not the solution they user was looking for. – Jeff Bluemel Mar 06 '18 at 14:37