Re: Updating remote MySQL databases

From: Cor Ligthert (notmyfirstname_at_planet.nl)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 15:45:08 +0100

John,

You can forget than my suggestion about a webservice. Your connection is
than over Internet directly to the database. It should be done using the
connections string. How that is done, expecially with MySQL, that is not my
stuff.

However I have searched the newsgroups for your question and saw answers,
maybe you can look yourself.

http://groups-beta.google.com/groups?q=internet+connectionstring+mysql&qt_s=Search+Groups

I hope this helps something,

Cor

>
> OK let me just clarify further what I'm aiming to do because it's
> narrower than you might perhaps have thought. The scenario is a
> WinForms program locally and a MySQL database on a remote server that
> I want to maintain with the WinForms program. The scope of the project
> doesn't involve writing any ASP.Net etc to deliver web pages on the
> remote server, that would probably be done with PHP or whatever. All
> that I'm asking about is how to maintain the remote MySQL database
> from a local ado.net program, nothing more.
>
> I just sort of imagined that I could send some SQL-type commands in
> the appropriate dialect down the TCP/IP connection from my local PC to
> the remote server, irrespective of the operating system running the
> server or whether it explicitly supports ado.net. Am I wrong about
> this? Are you implying that the remote server needs to be running some
> ado.net modules?
>
> Thanks
> JGD

Relevant Pages

  • Re: Best database for implementing a cache
    ... treated as a form a database, and it seems like thats kind of what you ... The remote server is situated in another continent and will be ... So for the database connection that would ... qualify as 'very fast' should let me acheive this theoretical limits ...
    (comp.lang.java.programmer)
  • Re: cant get aspnetdb.mdf to work on remote host
    ... that's what i mean by remote server. ... and they've been helpful in getting me connected to the database. ... i'm able to connect to it with this connection ... create a .sql file and had my host restore the database from that. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connect from sql query via IP adress - is i possible?
    ... > database, but we need to make some steps on the remote database, gather some ... > the connection every time when the remote server wants to transfer the data. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Connect from sql query via IP adress - is i possible?
    ... > database, but we need to make some steps on the remote database, gather some ... > the connection every time when the remote server wants to transfer the data. ...
    (microsoft.public.sqlserver.programming)
  • Re: Connect from sql query via IP adress - is i possible?
    ... > database, but we need to make some steps on the remote database, gather some ... > the connection every time when the remote server wants to transfer the data. ...
    (microsoft.public.sqlserver.olap)