FUDforum: comp.lang.php » <beg> ADODB PHP Extension Help </beg>

Home » Imported messages » comp.lang.php » <beg> ADODB PHP Extension Help </beg>

Show: Today's Messages :: Polls :: Message Navigator

Re: <beg> ADODB PHP Extension Help </beg> [message #176226 is a reply to message #176222]

Thu, 08 December 2011 13:29

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

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(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		<beg> ADODB PHP Extension Help </beg> By: Aul on Wed, 07 December 2011 23:34
		Re: <beg> ADODB PHP Extension Help </beg> By: Denis McMahon on Thu, 08 December 2011 09:03
		Re: <beg> ADODB PHP Extension Help </beg> By: Aul on Thu, 08 December 2011 18:41
		Re: <beg> ADODB PHP Extension Help </beg> By: The Natural Philosoph on Thu, 08 December 2011 18:44
		Re: <beg> ADODB PHP Extension Help </beg> By: Aul on Thu, 08 December 2011 19:28
		Re: <beg> ADODB PHP Extension Help </beg> By: The Natural Philosoph on Thu, 08 December 2011 20:32
		Re: <beg> ADODB PHP Extension Help </beg> By: Aul on Thu, 08 December 2011 21:23
		Re: <beg> ADODB PHP Extension Help </beg> By: Jerry Stuckle on Fri, 09 December 2011 01:16
		Re: <beg> ADODB PHP Extension Help </beg> By: Jerry Stuckle on Thu, 08 December 2011 13:29
		Re: <beg> ADODB PHP Extension Help </beg> By: Aul on Thu, 08 December 2011 18:42

Previous Topic:	Poll software recommendations
Next Topic:	regex help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 10:05:18 GMT 2024

Total time taken to generate the page: 0.05954 seconds