[Zope] ZOracleDA: compiling dco2.pyd for python23 on windows

[Elena Schulz]

Hi all,

I managed to get a dco2.pyd from dco2.c with MingW gcc on Windows but get an
ORA-21301 Error when I try to do a select, e.g. select * from MyTable
The Oracle connection is opended and the browse tab is working properly
showing MyTable in the list.

So there must be a subtle problem while compiling.

I'll append my compiling recipe so maybe someone can point me to a problem
there.

-- thanks a lot for any help, Elena

My compile.bat for compiling with gcc (version 3.2.3) and dllwrap (version
2.13.90)

@set PY_INCL="I:\Python\ActivePython232\include"
@set ORA_INCL="I:\Oracle\ora92\oci\include"

@set PY_LIBS="I:\Python\ActivePython232\libs"
@set ORA_LIBS="I:\Oracle\ora92\oci\lib\msvc"

rem generate the object-file:
gcc -I%ORA_INCL% -I%PY_INCL% -c dco2.c -o dco2.o

rem generate pyd-File:
dllwrap --dllname dco2.pyd --driver-name gcc --def dco2.def -o dco2.pyd
dco2.o -s --entry
_DllMain at 12 --target=i386-mingw32 -L%PY_LIBS% -lpython23 -L%ORA_LIBS% -loci

rem delete object-File:
del dco2.o