Ala James Briggs' post (attached), is there a way in adodbapi to leverage the fact that I have a UserDSN defined for my DB?
DG -----Original Message----- From: Vernon Cole [mailto:vernondc...@gmail.com] Sent: Thursday, October 07, 2010 10:44 AM To: Goldsmith, David; DB-SIG @ Python.org Subject: Re: [DB-SIG] Cookbook for Python access to Access? please pardon slowness, brevity & typos ... am on vacation & using Windows Mobile... step 1) load pywin32 from sourceforge. step 2) look in your Python site-packages/adodbapi/test folder for example. You can read or update ACCESS db using normal SQL statements and Python api calls. On 10/3/10, Goldsmith, David <dgol...@ecy.wa.gov> wrote: > Hi! I'm relatively new to DB's, though not to Python. I simply need to > learn how to programmatically put data--obtained using a Python > script--into an existing Access DB. I've searched and I've searched, > found a few brief examples of how to connect--using, e.g., sqlite3--but > when I execute a query, I'm told the file I've connected to is either > encrypted or not a DB; it may be the former (I don't know how to tell > for certain, but I can access it using MATLAB's database toolbox w/out > any explicit decryption), but it definitely is a DB. Can anyone refer > me to a relevant cookbook or pretty complete example set? Thanks! > > > > -------------------------------------- > David Goldsmith > Washington State Department of Ecology > Environmental Assessment Program > Modeling and Information Support Unit > 300 Desmond Drive | P.O. Box 47600 > Lacey, WA 98503 | Olympia, WA 98504-7600 > Tel: (360) 407-6194 > Fax: (360) 407-6884 > Email: david.goldsm...@ecy.wa.gov <mailto:david.goldsm...@ecy.wa.gov> > Station: C2D-59 > Web: http://www.ecy.wa.gov/programs/eap/ > <http://www.ecy.wa.gov/programs/eap/> > > > >
--- Begin Message ---I have no idea why the ODBC driver connect string doesn't work. I did notice you have a "User DSN", defined for Sandbox in the last graphic. A much simpler way to connect with an ODBC database when this is the case is the following: >>> import pyodbc >>> db=pyodbc.connect('DSN=Sandbox') An Example I just tried on old access database I have on my current PC : >>> db=pyodbc.connect('DSN=test') >>> c=db.cursor() >>> c.tables() <pyodbc.Cursor object at 0x00F2F250> >>> L=c.fetchall() >>> for each in L: ... print each ... (u'D:\\JUNK\\RABT.mdb', None, u'dbo_rabt_rec_differences', u'SYNONYM', None) (u'D:\\JUNK\\RABT.mdb', None, u'dbo_rabt_rec_reports', u'SYNONYM', None) (u'D:\\JUNK\\RABT.mdb', None, u'dbo_rabt_rec_results', u'SYNONYM', None) (u'D:\\JUNK\\RABT.mdb', None, u'MSysAccessObjects', u'SYSTEM TABLE', None) (u'D:\\JUNK\\RABT.mdb', None, u'MSysACEs', u'SYSTEM TABLE', None) (u'D:\\JUNK\\RABT.mdb', None, u'MSysObjects', u'SYSTEM TABLE', None) (u'D:\\JUNK\\RABT.mdb', None, u'MSysQueries', u'SYSTEM TABLE', None) (u'D:\\JUNK\\RABT.mdb', None, u'MSysRelationships', u'SYSTEM TABLE', None) (u'D:\\JUNK\\RABT.mdb', None, u'acurity', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'admin', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'admin_acurity', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'not_in_acurity', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'not_in_admin', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'rec_differences', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'rec_reports', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'rec_results', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'show rec results with subdatasheet detail', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'show rec results with subdatasheet summary', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'subdatasheet detail', u'VIEW', None) (u'D:\\JUNK\\RABT.mdb', None, u'subdatasheet summary', u'VIEW', None) >>>
--- End Message ---
_______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
