Re: Connect to table on web

"Theo Pistorius" <theo+nospamremove+@xxxxxxxxxxxxx> wrote in
news:44f682e6@xxxxxxxxxxxxxxxxxxxxxx:

Ok, let me rephrase that then.
My web host already has mysql running on a linux box.

Is it possible to connect to the mysql tables with a desktop application
and add/delete/edit the mysql data with something.

Yes it is possible to connect to any sql server through the internet.
Now the problem is
1) for security reasons most of the providers do not give access
to the sql server from outside their LAN.
2) Most of sql trasnport mechanisms are not designed to work through the
internet making it slow to work.

You need to ask your host to be sure but I do not think that they are going
to open up the SQL port.

Is your host on linux only or it has windows server as well.

I'm stupid here, totally our of my league but logic tells
me there must be a way that is not too complex.

The simplest way that I can thing of is to write a small ISAPI proxy
which will connect with the sql server internally and will give you
the ability to execute any sql command and it will return the result
formated (eg CSV, XML etc). On the client side using a Tclientdataset
to hold the data let the user manipulate them and post back the changes
in sql commands.

You need to understand that through the internet you can not have direct
access to the data. This meens that you can't lock a record while it is
edited and multiple clients can make changes to the data.
This creates multiple problems which are outside the scope of this thread.

first you need to talk with your host to see if you can have access
directly to mySQL then I need to know if the host has windows web
servers as well as linux or only linux and then we can be more specific
to a solution of your problem.

Regards
Yannis.
.

Relevant Pages

  • Re: mysql
    ... susposed to be a ".sql" file somewhere, ... The reason I ask is ... Wouldn't you be better served by asking your mysql questions on ... Linux good to have it said in the same breath. ...
    (alt.os.linux.suse)
  • Re: Install SQL on Linux
    ... SQL Server requires a Microsoft operating system. ... boss isn't referring to MySQL instead? ... platforms including both Windows and Linux. ... > My boss and I had a heated discussion on installing SQL ...
    (microsoft.public.sqlserver.setup)
  • Best Database For Ruby
    ... I want to learn DB and SQL using Ruby ... Everyone at work tells me MySQL is the best... ... It doesn't look like I can get this for linux. ...
    (comp.lang.ruby)
  • Re: Add new cluster and use existing LUNs?
    ... Meta-volumes are dedicated to a single host, single activity (OS, swap file, ... varied activity (DBMSes, Messaging Server, File Server, Web Servers, ... Some of the physical spindle limitations can be addressed through the SAN ... >> test would be to run a simulated SQL I/O load on the newly created LUNs ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk Server 2006 - Running Host Instance consumes 100% CPU when "Allow Host Tracking" is
    ... the sql script needed to be run to install the ... BizTalk Server 2006 - Running Host Instance consumes 100% ...
    (microsoft.public.biztalk.general)