ODBC comments

From: Date: Sat, 19 Jun 1999 14:48:28 +0000
Subject: ODBC comments
Groups: php.dev 
Request: Send a blank email to php-dev+get-7151@lists.php.net to get a copy of this message
Dear Development Team, I work with PHP3 for a long time and I like it so much. Thank you very much all of your work. I use most of the time in PHP3 the ODBC connectivity features. I used MySQL-MyODBC on RedHat 5.2 Linux, Oracle-RDB-ODBC on NT4 and MS Access on Windows 95/NT. In order to work with all of that I had to do some very small changes in the source "unified_odbc.c" code. I think that this solution can help to somebody else also that is why I send this letter to you. I attache both the modified "unified_odbc.c" and the diff files. Originally I have downloaded the 3.0.9 version of PHP. Key points of changes: 1. Instead of using HAVE_SQL_EXTENDED_FETCH compiler directive I suggest to use runtime variable "conn_ptr->fetch_abs" which is used in the source. 2. Using SQLDriverConnect instead of SQLConnect. The decision would not based on compiler directive but the parameter string like "DSN=anydsn;". I do not know exactly how would be the best. The implementation from version 3.0.6 try to apply something like what my imagination is. 3. SQLDescribeParam was not supported by MS Access so I tried to do something to work with that. It has only meaning in insert and update statements. 4. To execute SQLBindCol was sometime unsuccessful before SQLExecute so I moved it after SQLExecute. Please spend some time on my experiences and results and if you find it useful include it in the next patch as it is or as you like it. Please send me back a message if I could help a bit or not. Thank you very much and I wish good luck in all of your life and work, Miklos Krivan Address: H-2600 Vac Nagymezo u. 55. 4/14. Hungary E-mail: mkrivan@mail.toig.matav.hu or krivan.miklos@ln.matav.hu

« previous php.dev (#7151) next »