mxODBC and delete

[richard_chamberlain]

hmmm,

You could try a free database like mySql. I think you need to discover where
the issue lies.

It sounds like your ODBC connection is ok, so I take it it must be a problem
with connecting to that particular database.

Richard


Peter Leveille <psl at mitre.org> wrote in message
news:392170BD.DC816592 at mitre.org...
>
>
> 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 ???????')