mxODBC and delete

[latrada]

Peter,

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?

I presume from below that you're connect with a user name and password -
does this have authority to delete?

Have you tried a different database?

Richard

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 ???????')