Re: [phpesp-dev] Port to ODBC

[Stefan C. <sch...@ea...>]

Continuing port to PostgreSQL on IIS. I think that the ODBC layer has troubles 
if one doesn't call "odbc_free_result" properly. Be aware of that because not 
doing so (if that is the problme, I can hardly prove that) tends to lead to 
very strange behaviour.

I'm also almost done with rewriting the DB tables. I'll send them here when 
they'll be up and running on Oracle.

stF

> Continuing my work to port phpESP to ODBC/Oracle, I stumbled against a few
> problem because phpESP was primarily developped for mySQL. When moving to
> Oracle beware that there's no auto_increment and thus we must use sequence.
> To be able to predevelop outside the heavily controlled Oracle environment,
> I figured out that it'd be better if I used PostGreSQL, because it provides
> sequences and, more importantly, good support for subqueries (an area where
> MySQL traps you way too much in its own DB paradigm (IMHO)). Therefore,
> I'mprobably going to try to port everything to PostgreSQL and when I'm
> done, I'll move everything to Oracle. Again, it may sound a little
> overkill, but the DBA are so reluctant/busy to leave me alone in a ORA
> sand-box that I have to go my own way.
>
> stF
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel