|
I wrote a program for a friend a while
back, simply a small database app that runs on a single pc. Now he wants to
give it to 2 other people and have the database on his webserver. His
provider gives him a MS-SQL server to use. I'm not really wanting to
convert this to a full web based app. Ideally I'd just like to convert
my program to talk to the MSSQL database to get its information.
What DBMS software did your original application
use?
In searching for information about doing this,
I'm getting flooded with an incredible amount of information and I'm
having a difficult time separating the wheat from the chaff.
Looking at his provider's website, they mention that the DB is available, but
nothing further. Clearly they expect me to know how to use the
thing.
Is is possible for a remote .exe to hit the DB
directly and run queries against it, or would I have to have a program running
on the server that hits the DB and my remote program talks to
that?
What is the best (read "fastest") way to go about
this?
I'm not much
into MS-SQL server, but if it's anything like other major DBMS's, then on
connection establishment you should use a server address and port number, and
the client will create a socket talking to it. This means that to make the
app work with a remote database, it should be sufficient to use the server's
address (instead of localhost) and port number to connect to the remote server
and send queries on that connection.
Man is something that must be overcome: and
therefore you will love your virtues,- for you will perish by
them.-
-Thus Spoke Zarathustra, F. W.
Nietzsche |
|
_______________________________________________
msvc mailing list
[email protected]
See http://beginthread.com/mailman/listinfo/msvc_beginthread.com for
subscription changes, and list archive.
