AW: [Zope-DB] ZADODA

[Charlie Clark]

On 2004-10-21 at 14:23:29 [+0200], juergen.hauptmann <juergen.hauptmann at imc-krems.ac.at> 
wrote:
> 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?

Charlie

> Jürgen
> 
> -----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.
> 
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_globals_50u1.asp
> 
> 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!
> 
> Charlie