|
It's possible, but the provider must let you
connect to the DB using TCP/IP on port 1433. On the other hand, it depends how
is the SQL Server configured. If it requires windows authentification, then it's
not possible.
I have never tryed it, but it should
work.
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.
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?
Thank you,
Adam
|
_______________________________________________
msvc mailing list
[email protected]
See http://beginthread.com/mailman/listinfo/msvc_beginthread.com for
subscription changes, and list archive.
