mxODBC and delete
psl at mitre.org
Tue May 16 18:01:01 CEST 2000
> I can run a delete command on my setup (i've just checked).
> I suppose you've checked that ODBC set up ok?
> Can you run a select statement?
Yes, and I can use insert.
> I presume from below that you're connect with a user name and password -
> does this have authority to delete?
Yes, I logged into the Oracle SQL *Plus GUI using the same username and
password, and I can delete through that GUI.
> Have you tried a different database?
Nope. I only have one database to work with.
> Peter Leveille <psl at mitre.org> wrote in message
> news:3920530E.79AACCDC at mitre.org...
> > I have been using the mxODBC package for access to a database. This has
> > been working great, until a recent problem that I have had. When I try
> > running the following code, python just freezes up. Does anyone know
> > what I am doing wrong, or if there is another way to do it?
> > >>> import ODBC.Windows
> > >>> db = ODBC.Windows.Connect('????????','???','??????')
> > >>> c = db.cursor()
> > >>> c.execute('DELETE FROM ???????')
More information about the Python-list