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

[Chris Withers]

(please note change of list)

Elena Schulz wrote:

> 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.

The exception type, value and traceback when you get the ORA-21301 would also be 
handy...

> 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

cheers,

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk