Programming with dBASE - connecting to MYSQL

Author

connecting to MYSQL

John Noble

2005-11-11, 3:23 am

Is this possible -

Create a standard desktop application that connects to a MYSQL database on the web.

If the above were possible - Would there be a time lag in showing the datalinked controls on the forms.

Perhaps there is a article / bulletin that I missed that explains how to do this???

Thanks,

John

Michael Nuwer [dBVIPS]

2005-11-11, 7:23 am

John Noble wrote:
> Is this possible -
>
> Create a standard desktop application that connects to a MYSQL database on the web.

Yes, this is possible.

>
> If the above were possible - Would there be a time lag in showing the datalinked controls on the forms.

Yes, it is slow in the testing I've done.

>
> Perhaps there is a article / bulletin that I missed that explains how to do this???

The following is a note for Interbase.

http://www.nuwermj.potsdam.edu/dSamples/docs/IBTest.htm

This server is live (used for practicing; no real data) and the
instructions should work you if you would like to test with it.

John Noble

2005-11-11, 11:23 am

Michael Nuwer [dBVIPS] Wrote:

> The following is a note for Interbase.
>
> http://www.nuwermj.potsdam.edu/dSamples/docs/IBTest.htm
>
> This server is live (used for practicing; no real data) and the
> instructions should work you if you would like to test with it.

Thanks for your help Michael.
However after following the instructions I could not get connected.
Was prompted 'Unable to complete network request to host "137.143.156.74"'

Perhaps the username / password have changed???

When you said it was slow - How slow is slow?

I was wondering if it were common practice to have data held on a web server that is accessed by desktop applications?

I suppose an alternative would be to create a web app using a browser as front end but I know dbase has some limitations regarding compatible web servers.

Michael Nuwer [dBVIPS]

2005-11-12, 7:23 am

John Noble wrote:
> Michael Nuwer [dBVIPS] Wrote:
>
> Thanks for your help Michael.
> However after following the instructions I could not get connected.
> Was prompted 'Unable to complete network request to host "137.143.156.74"'
>
> Perhaps the username / password have changed???

Nope, no change in username or password. It all working for me as a
remote system. Perhaps your firewall is blocking the address or the port?

>
> When you said it was slow - How slow is slow?

This depends on the size of the tables. For tables with less than 100
records the speed is fine. When there are 10,000 records it is
noticeable slow. If you can use SQL select...where statements in your
code, this will speed things up.

>
> I was wondering if it were common practice to have data held on a web server that is accessed by desktop applications?

Do you mean that the data server and the web server are installed on
same computer? I can't say whether it is common practice, but I had a
system that did just that. A PHP web app and a dBASE desktop app
working with same mySQL database. The dBASE app was, however, running
over a LAN not the Internet.

>
> I suppose an alternative would be to create a web app using a browser as front end but I know dbase has some limitations regarding compatible web servers.

I know of now limits with Apache. I have not heard of any limits with
the Microsoft server.

Robert Bravery

2005-11-12, 9:23 am

Hi Michael,
I got this working. Its great. My question is, would'nt a web app be faster.
Have you tested the speed difference between a client/desktop app connecting
to the IB server via the internet, and a web app doing the same.
Be interesting to see the results

Thanks
Robert

"Michael Nuwer [dBVIPS]" <nuwermj@yahoo.com> wrote in message
news:BY0tzhr5FHA.1228@news-server...
> John Noble wrote:
on the web.[color=darkred]
>
> Yes, this is possible.
>
>
datalinked controls on the forms.[color=darkred]
>
> Yes, it is slow in the testing I've done.
>
do this???[color=darkred]
>
> The following is a note for Interbase.
>
> http://www.nuwermj.potsdam.edu/dSamples/docs/IBTest.htm
>
> This server is live (used for practicing; no real data) and the
> instructions should work you if you would like to test with it.

Michael Nuwer [dBVIPS]

2005-11-12, 8:23 pm

Robert Bravery wrote:
> Hi Michael,
> I got this working. Its great. My question is, would'nt a web app be faster.

A CGI app is a client to the data server just like a desktop app is a
client. So, the speed parameters would be the same for both types of
apps. If the web server is in SA and the data server is in Germany the
web app would not be faster.

> Have you tested the speed difference between a client/desktop app connecting
> to the IB server via the internet, and a web app doing the same.

No, I've not done this test. I have always run the web server, data
server and desktop app on the same LAN.

> Be interesting to see the results

You now have the ability to make out this test against my data server.

Michael Nuwer

Robert Bravery

2005-11-13, 3:23 am

HI,

I can't do the test properly, as I dont have access to a web app selecting
data from the same server. However, I did a test with a web app from our
server, and a small app selecting data from your server. The web app seems
faster to the eye, altho a proper test reveals that both would return data
in about 2 secs. I suppose we a accustomed to the web/browser delay, whereas
the desktop app should be almost instant.
So if my understanding is correct.
An client app, selecting data from a remote server, should not be any slower
than a web/browser app selecting data from same server.

Robert

"Michael Nuwer [dBVIPS]" <nuwermj@yahoo.com> wrote in message
news:ZY95Bu85FHA.1228@news-server...
> Robert Bravery wrote:
faster.[color=darkred]
>
> A CGI app is a client to the data server just like a desktop app is a
> client. So, the speed parameters would be the same for both types of
> apps. If the web server is in SA and the data server is in Germany the
> web app would not be faster.
>
connecting[color=dar
kred]
>
> No, I've not done this test. I have always run the web server, data
> server and desktop app on the same LAN.
>
>
> You now have the ability to make out this test against my data server.
>
> Michael Nuwer

Sponsored Links