Interesting ODBC problem

[Geoff Berrow]

I have just converted a guestbook to use an Access database rather than
MySQL (don't ask...) via odbc and have come across an unusual problem.

There is an admin screen which simply accesses all records and displays
them. All worked fine on my machine. But on my friend's machine the
code times out.

Now I was under the impression that all processing would be complete
/before/ any html was sent out. Surely the processing cannot be
dependent on the speed of the connection!

If I use up my bandwidth by downloading an mp3 or something I can
recreate the error.

Has anyone else come across anything like this?
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Geoff Berrow]

Re: Interesting ODBC problem

I noticed that Message-ID: <8p7j70pldrp5ks rbaakf8geo97bro 4vvu6@4ax.com>
from Geoff Berrow contained the following:

[color=blue]
>Now I was under the impression that all processing would be complete
>/before/ any html was sent out. Surely the processing cannot be
>dependent on the speed of the connection![/color]

OK, not as interesting as I thought. Does /anyone/ have any idea what's
going on?
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Garp]

Re: Interesting ODBC problem


"Geoff Berrow" <blthecat@ckdog .co.uk> wrote in message
news:8p7j70pldr p5ksrbaakf8geo9 7bro4vvu6@4ax.c om...[color=blue]
> I have just converted a guestbook to use an Access database rather than
> MySQL (don't ask...) via odbc and have come across an unusual problem.[/color]
<snip>

No, I'm gonna hafta ask...

Garp

[Garp]

Re: Interesting ODBC problem


"Geoff Berrow" <blthecat@ckdog .co.uk> wrote in message
news:hebl70lcha 5sip00rmc3qk4ou b90uc513m@4ax.c om...[color=blue]
> I noticed that Message-ID: <8p7j70pldrp5ks rbaakf8geo97bro 4vvu6@4ax.com>
> from Geoff Berrow contained the following:
>
>[color=green]
> >Now I was under the impression that all processing would be complete
> >/before/ any html was sent out. Surely the processing cannot be
> >dependent on the speed of the connection![/color]
>
> OK, not as interesting as I thought. Does /anyone/ have any idea what's
> going on?
> --[/color]

It's not uninteresting, there's just not enough to go on. I've not tried
Access through PHP (after years of hell doing it through C++), but I imagine
the problems are the same.

Timeouts are a pain to track down (no error=no help), but first, is it
working outside of PHP? Outside the web server?

Garp

[Geoff Berrow]

Re: Interesting ODBC problem

I noticed that Message-ID:
<d5Cec.2031$725 .19925180@news-text.cableinet. net> from Garp contained
the following:
[color=blue]
>It's not uninteresting, there's just not enough to go on. I've not tried
>Access through PHP (after years of hell doing it through C++), but I imagine
>the problems are the same.
>
>Timeouts are a pain to track down (no error=no help), but first, is it
>working outside of PHP? Outside the web server?[/color]

Not sure what you mean. I've simply created an Access database and
uploaded it to the server. The ISP has a utility to create a DSN which
I then use PHP to connect to via ODBC.

It works fine on my dial up connection. But my friend has a very slow
connection and it times out. And it's only 50 text records. What I
can't understand it why it is dependent on the connection speed at all.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Geoff Berrow]

Re: Interesting ODBC problem

I noticed that Message-ID:
<82Cec.2026$kY4 .19831876@news-text.cableinet. net> from Garp contained
the following:
[color=blue][color=green]
>> I have just converted a guestbook to use an Access database rather than
>> MySQL (don't ask...) via odbc and have come across an unusual problem.[/color]
><snip>
>
>No, I'm gonna hafta ask...[/color]

OK. My friend has a reseller account with an ISP called Fasthosts.
They have a choice of servers on which he can host as many sites as he
likes for a flat fee. He can host on Linux at no extra cost, but
Windows servers cost an extra GBP 10. However, there is no extra cost
for Access databases. On the other hand, if he chooses Linux it costs
GBP 50 to add a MySQL database.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Garp]

Re: Interesting ODBC problem


"Geoff Berrow" <blthecat@ckdog .co.uk> wrote in message
news:tkem70denn mlntpehpdtqsibl nh6i6o7ai@4ax.c om...[color=blue]
> I noticed that Message-ID:
> <82Cec.2026$kY4 .19831876@news-text.cableinet. net> from Garp contained
> the following:
>[color=green][color=darkred]
> >> I have just converted a guestbook to use an Access database rather than
> >> MySQL (don't ask...) via odbc and have come across an unusual problem.[/color]
> ><snip>
> >
> >No, I'm gonna hafta ask...[/color]
>
> OK. My friend has a reseller account with an ISP called Fasthosts.
> They have a choice of servers on which he can host as many sites as he
> likes for a flat fee. He can host on Linux at no extra cost, but
> Windows servers cost an extra GBP 10. However, there is no extra cost
> for Access databases. On the other hand, if he chooses Linux it costs
> GBP 50 to add a MySQL database.[/color]

That's one screwed-up pricing model. Everyone knows Access is a resource
hog - on my machines it's frequently responsible for 100% CPU load. 8)

Garp