Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #4023

Re: <beg> ADODB PHP Extension Help </beg>

Show all headers | View raw

On 12/7/2011 6:34 PM, Aulë wrote:
> Hello, everyone.
>
> I have the latest builds of Apache, MySql and PHP under Windows XP. I
> have configured and tested the setup to verify it works. I want to take
> advantage of the ease of porting that the ADODB PHP extensions will
> afford as I begin conversion of my old, outdated VB/Access projects to
> HTML/PHP/MySql. I am using mysqli as my database connection.
>
> I don't want to reinvent the wheel (which I won't do well or timely,
> since robust error-handling doesn't come cheap, time-wise), so I looked
> for a decent library with pre-built database querying routines. ADODB
> looked quite useful, since all my old database apps are written in
> VB/DAO. Porting to the ADODB interface to PHP/MySql will significantly
> reduce my conversion labors.
>
> Sadly, it seems that I can only return one-column recordsets by this
> method, though, since any attempt to return a recordset with two or more
> columns horribly crashes Apache with the generic 0xC0000005 exception.
> I'm assuming I've set something up wrong, but so much else works.
>

<snip>

Hmmm, an application should never be able to cause Apache to die with an 
exception.  There may be an incompatibility between your version of PHP 
and the one ADODB was compiled with, or a bug in the ADODB code.  It may 
also be it requires the php_mysql extension (which I see you have 
disabled).  I don't know.

In any case, your best support is from the people who wrote the code 
(which I see you have done).  They know their product better than anyone 
else.

But personally, if I were converting it, I'd just rewrite the code using 
mysqli or PDO.  If your VB/DAO code is that old, chances are it has some 
security holes in it also.  Additionally, there are differences between 
Access and MySQL, so you'll have to make changes anyway.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

<beg> ADODB PHP Extension Help </beg> Aulë <aule.vala@gmail.com> - 2011-12-07 18:34 -0500
  Re: <beg> ADODB PHP Extension Help </beg> Denis McMahon <denismfmcmahon@gmail.com> - 2011-12-08 09:03 +0000
    Re: <beg> ADODB PHP Extension Help </beg> Aulë <aule.vala@gmail.com> - 2011-12-08 13:41 -0500
      Re: <beg> ADODB PHP Extension Help </beg> The Natural Philosopher <tnp@invalid.invalid> - 2011-12-08 18:44 +0000
        Re: <beg> ADODB PHP Extension Help </beg> Aulë <aule.vala@gmail.com> - 2011-12-08 14:28 -0500
          Re: <beg> ADODB PHP Extension Help </beg> The Natural Philosopher <tnp@invalid.invalid> - 2011-12-08 20:32 +0000
            Re: <beg> ADODB PHP Extension Help </beg> Aulë <aule.vala@gmail.com> - 2011-12-08 16:23 -0500
              Re: <beg> ADODB PHP Extension Help </beg> Jerry Stuckle <jstucklex@attglobal.net> - 2011-12-08 20:16 -0500
  Re: <beg> ADODB PHP Extension Help </beg> Jerry Stuckle <jstucklex@attglobal.net> - 2011-12-08 08:29 -0500
    Re: <beg> ADODB PHP Extension Help </beg> Aulë <aule.vala@gmail.com> - 2011-12-08 13:42 -0500

csiph-web