Updating sql server remotely

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

We have our web site remotely hosted by a service provider. We need to, from
time to time, remotely upload transactions to the site from our office
vb.net app. The question is how can I connect to the remote site's sql
server using vb.net? Do I need to use a control etc.? What if I want to post
values as parameters to an asp.net page?

Thanks

Regards
 
If the SQL Server port is open (it might not be) you _might_ be able to
connect to it directly via the IP address. However, if it was my web site
and server, I would block the port. I would take another approach. Write a
DTS application that accepts a delimited file that updates the data and pass
it a file to post to the DB.
hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
It really depends on the volume of data you expect to push up to the server.
An ASP page would work and a web service might also but neither approach
would be as performant.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
IMHO it is a really really bad idea to post your Sql Server to the internet.
It is a huge security risk, from brute force attacks and denial of service
to just getting access to your server by decompiling/memory dumping your
client application. You should rely on webservices/iis/other to provide a
middle layer between your application and your server. It is not going to be
as performant but in my mind it is definitely worth it.

Hope this helps,
 
If on the other hand I access the sql server directly then it is not
recommended on security grounds. So which approach should I use to remotely
update a database?

Thanks

Regards
 
FTP a file to the server. Use a server-side application that you launch
using a secure SSL connection to DTS the file into the database. Better yet,
setup a VPN channel (easy to do) to the server. At this point you can safely
setup a "direct" connection, but I would still use BCP or DTS to upload the
data.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top