AW: [Zope-DB] ZADODA
charlie at egenix.com
Thu Oct 21 09:22:10 EDT 2004
On 2004-10-21 at 14:23:29 [+0200], juergen.hauptmann <juergen.hauptmann at imc-krems.ac.at>
> Thanks, But the problem is that the IDENTITY STATEMENT works now, but the
> Insert Statements don't work now, the IDENTITY Statemment works alone I a
> ZSQL METHOD, I have tested it...
> I think the problem is the ZADO DA. I get the same Error if I want to
> execute a stroed procedure...
It certainly seems to be related to the pywintypes module. Have you tried our mxODBC Zope DA?
> -----Ursprüngliche Nachricht-----
> Von: Charlie Clark [mailto:charlie at egenix.com]
> Gesendet: Donnerstag, 21. Oktober 2004 14:07
> An: juergen.hauptmann
> Cc: zope-db at zope.org
> Betreff: AW: [Zope-DB] ZADODA
> On 2004-10-21 at 13:40:40 [+0200], juergen.hauptmann
> <juergen.hauptmann at imc-krems.ac.at> wrote:
> > I use MS SQL Server 2000.
> > I can now read the last inserted ID with: SELECT @@IDENTITY as lastid
> > But now I cannot do any insert Statement I get the following error:
> > Error, pywintypes.com_error: (-2147352567, 'Exception occurred.', (0,
> > 'ADODB.Recordset', 'Operation is not allowed when the object is closed.',
> > 'C:\\WINDOWS\\HELP\\ADO270.CHM', 1240653, -2146824584), None)
> This error is fairly self-explanatory. I think you need to check with your
> documentation about this function.
> I've only briefly flown over this but it seems that you might indeed need
> to call this function within a single SQL statement. But it looks like
> there are other possibilities of accessing this value.
> Good luck!
More information about the Zope-DB