By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,213 Members | 2,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,213 IT Pros & Developers. It's quick & easy.

Updating site database remotely

P: n/a
Hi

We have our web site remotely hosted by a service provider. What we need is
to from time to time remotely upload transactions to the site from our
office vb.net database app, so the site can display the information for site
visitors. I am considering two scenarios, could someone tell me which is
better?

Scenario 1: Use SQL Server as site backend and connect remotely to the db
using ip/port/user/pass.

Scenario 2: Use either access or SQL Server and pass parameters to an
asp.net page which will update the database.

Thanks

Regards
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi John,

You might consider webservices - passing whole dataset.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:eB****************@TK2MSFTNGP12.phx.gbl...
Hi

We have our web site remotely hosted by a service provider. What we need is to from time to time remotely upload transactions to the site from our
office vb.net database app, so the site can display the information for site visitors. I am considering two scenarios, could someone tell me which is
better?

Scenario 1: Use SQL Server as site backend and connect remotely to the db
using ip/port/user/pass.

Scenario 2: Use either access or SQL Server and pass parameters to an
asp.net page which will update the database.

Thanks

Regards

Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.