Using DAO and Python

dsavitsk dsavitsk at e-coli.net
Sun Apr 23 15:01:27 EDT 2000


I am jumping in in the middle here...
I have a VB program that needs to be more dynamic than VB wants to be.  So I
use vb to generate a python script that the user can then modify.  The
primary purpose of the script is to use DAO or ADO to connect to a ms access
db (it also connects to an NCS OpScan OMR Scanner, but that is a different
story).
my problem thus far, and there will be more, is just getting python to use
dao correctly.
here is what i have tried (esentially following the example on pg 252 of
python programming on win32)
1. ran makepy and selected microsoft dao 3.6 from the list
2. in PythonWin typed
>>> import win32com.client
>>> daoengine = win32com.client.Dispatch('DAO.DBEngine')

at this point there is an error
esentially i know i oversimplified this way too much, but any suggestions as
to what i left out will be greatly appreciated.

---------------------------------------------------------------------
dsavitsk at e-coli.net
http://www.e-coli.net
---------------------------------------------------------------------






More information about the Python-list mailing list