Re: [PHP4BETA] ODBC functions for PHP 4, improvements, survey

Leo Baschy wrote: > Greetings, > > I have spent about half of my work / coding time in the last two months on coding (changes to > the source code of) the ODBC module of PHP. I had / have specific needs for a project. I am about > ready to roll my code into the official version. > > With PHP 4 about to go final I might as well make sure / take some responsibility for / > coordinate that ODBC works well in PHP 4. (Unless someone else tells me they want to do that right > now.) Well AFAIK, Andreas has been doing this up to now. This of course if all IMHO while there are things that are less than perfect I would be a bit worried about major changes to the code this far on in the PHP4 process. And perhaps we should look at the changes first, SQL Server does some strange things with stored procedures so it may not (I don't know without trying) work as expected with other databases. The last time I looked at some code to support stored procedures it looked as if it may have a overhead for normal queries, so perhaps this should be looked at. I suspect that the connect close function you have changed may be a fix for something Andreas has already done. While my major concern is the support for unixODBC on Unix/Linux and the Easysoft ODBC-ODBC bridge we would need to check that the new code worked with all the other databases that people use. What does need changing at least is to check the return codes from the numerous SQLNumResultCol, these can fail with several databases (Postgres being one of them) Just my 2d's worth. > To smooth the process (avoid conflicts) I would like to know (from _you_): > - are you using ODBC ? Yes > > - which database MySQL, Postgres, MS Sqlserver, DB2, OOB, Easysoft RDBMS > - which operating system Linux > - which Web server Apache 1.3.9 and above > - which version of PHP 3.0.9 and PHP4 CVS > - are you changing PHP source yourself ? When required > - are you actively changing PHP's ODBC functions Not today, but in the past > - are you compiling yourself or are you using the built binary ? Compiling myself > (would you notice if something breaks?) Maybe > - which compiler environment gcc > > I'd like to know who uses it how much, to have better confidence whether we cover most > versions of systems in use. We use it a LOT. but just with the set of systems we use. -- Nick Gorham, nick@lurcher.org Found in a sig... Give a man a match and he'll be warm for an hour... Set him on fire and he'll be warm for the rest of his life.