Problem in generated files with makepy and Microsoft ADO

[Martin Stettner]

Hi,

when trying to generate the wrapper classes for Microsofts ADO Library
(Version 2.8) with makepy, I run into the following problem. Here's what I
do (I use ActiveState Python 2.4.1.245)

1.) Running makepy, selecting "Microsoft ActiveX Data Object 2.8"

2.) Starting PythonWin IDE

3.) When I type the following

import win32com.client .Dispatch
rs = win32com.client .Dispatch("ADOD B.Recordset")

I get this error

Traceback (most recent call last):
File "<interacti ve input>", line 1, in ?
File
"C:\Programme\P ython24\Lib\sit e-packages\win32c om\client\__ini t__.py", line
96, in Dispatch
return __WrapDispatch( dispatch, userName, resultCLSID, typeinfo,
UnicodeToString , clsctx)
File
"C:\Programme\P ython24\Lib\sit e-packages\win32c om\client\__ini t__.py", line
38, in __WrapDispatch
klass = gencache.GetCla ssForCLSID(resu ltCLSID)
File
"C:\Programme\P ython24\Lib\sit e-packages\win32c om\client\genca che.py", line
184, in GetClassForCLSI D
mod = GetModuleForCLS ID(clsid)
File
"C:\Programme\P ython24\Lib\sit e-packages\win32c om\client\genca che.py", line
245, in GetModuleForCLS ID
makepy.Generate ChildFromTypeLi bSpec(sub_mod, info)
File "C:\Programme\P ython24\lib\sit e-packages\win32c om\client\makep y.py",
line 307, in GenerateChildFr omTypeLibSpec
__import__("win 32com.gen_py." + dir_name + "." + child)
File
"C:\Programme\P ython24\lib\sit e-packages\win32c om\gen_py\2A751 96C-D9EB-4129-B803-931327F72D5Cx0x 2x8\_Recordset. py",
line 55
def Collect(self, Index=defaultNa medNotOptArg):
return self._ApplyType s_(-8, 2, (12, 0), ((12, 1),), 'Collect',
None,Index)
^
SyntaxError: invalid syntax

The Line containing the error reads as follows (in the generated
_Recordset.py file)

# The method Collect is actually a property, but must be used as a method
to correctly pass the arguments
def Collect(self, Index=defaultNa medNotOptArg):
return self._ApplyType s_(-8, 2, (12, 0), ((12, 1),), 'Collect',
None,Index)

Strangely, if I delete the comment line, everything runs fine! I've noticed
a similar problem with the Properties.py file when I was using the adodbapi
module: There I had to delete the generated line

from win32com.client import Dispatch

which also seems perfectly correct to me.

I cannot see any error in the code. As I would like to deploy my application
without having my customer to edit this line manually I would appreciate any
hint (compiler bug? Bug in the ADO type library?)!

Thanks in advance

Martin

[Martin Stettner]

"Martin Stettner" <ma*********@co mplement.xxx.at > schrieb im Newsbeitrag
news:d8******** **@newsreader1. utanet.at...

Hi,

when trying to generate the wrapper classes for Microsofts ADO Library
[bigsnip...]
Martin

Ok, I found some references to similar bugs at

http://www.python.org/sf/1163244,
http://www.python.org/sf/1089395 and
http://www.python.org/sf/1101726.
It seems that Python 2.4.1 has problems with mbcs encodint. I'll try to
install the actual version of the pywin32 package (build 204) which seems to
implement a workaround.cuMa rtin