mxODBC and delete

[Peter Leveille]

latrada wrote:
> 
> 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?
> 

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.

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