Accessing data on a web server

I have written a VB6 app for a user that uses ADO to connect to a MySQL
database (through the MyODBC driver). Not being much of a internet
programmer, the user asked me if it is possible to move the the database to
a web server and have the client program access the database on the web
server instead of the local machine.

The user seems to think all that needs to be done is to modify the ADO
connection string to point to an http or ftp address (instead of a server
name). I have little to no experience in this area, but from what I
understand I don't think this is possible using a standard VB6 program -
correct? Doesn't the client need to be written in ASP or something similar?
TIA

Daryl

This sample can connect to a web server version of MySQL:
http://www.veign.com/vrc_codeview.asp?type=app&id=92

This all depends on how the web host has the MySQL databases setup. Some
have it setup in a way that you will not be able to connect to it remotely -
can only use something like phpMyAdmin set to local. If the web host allows
remote connections then all you will need is the IP address of the server
containing the MySQL DB....

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--

"Daryl Muellenberg" <dmuellenberg.RemoveThis@agris.com> wrote in message
news:eLIxV7iDFHA.3368@TK2MSFTNGP10.phx.gbl...
> I have written a VB6 app for a user that uses ADO to connect to a MySQL
> database (through the MyODBC driver). Not being much of a internet
> programmer, the user asked me if it is possible to move the the database
to
> a web server and have the client program access the database on the web
> server instead of the local machine.
>
> The user seems to think all that needs to be done is to modify the ADO
> connection string to point to an http or ftp address (instead of a server
> name). I have little to no experience in this area, but from what I
> understand I don't think this is possible using a standard VB6 program -
> correct? Doesn't the client need to be written in ASP or something
similar?
> TIA
>
> Daryl
>
>