Updating sql server remotely

[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

[William \(Bill\) Vaughn]

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.
__________________________________

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:uC****************@tk2msftngp13.phx.gbl...

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

[John]

Anything wrong in posting data via an asp.net page? As it is much simpler.

Regards
"William (Bill) Vaughn" <bi**************@nwlink.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

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. __________________________________

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:uC****************@tk2msftngp13.phx.gbl...

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

[Ken Tucker [MVP]]

Hi,

Take a look at web services.
http://msdn.microsoft.com/webservice...servbasics.asp

Ken
-----------------
"John" <jo**@nospam.infovis.co.uk> wrote in message
news:uC****************@tk2msftngp13.phx.gbl...

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

[William \(Bill\) Vaughn]

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.
__________________________________

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:Oj******************@TK2MSFTNGP11.phx.gbl...

Anything wrong in posting data via an asp.net page? As it is much simpler.

Regards
"William (Bill) Vaughn" <bi**************@nwlink.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

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.

__________________________________

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:uC****************@tk2msftngp13.phx.gbl...

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

[Angel Saenz-Badillos[MS]]

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,

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:uC**************@tk2msftngp13.phx.gbl...

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

[John]

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
"William (Bill) Vaughn" <bi**************@nwlink.com> wrote in message
news:Oo**************@TK2MSFTNGP09.phx.gbl...

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. __________________________________

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:Oj******************@TK2MSFTNGP11.phx.gbl...

Anything wrong in posting data via an asp.net page? As it is much simpler.

Regards
"William (Bill) Vaughn" <bi**************@nwlink.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

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.

__________________________________

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:uC****************@tk2msftngp13.phx.gbl...
> 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
>
>
>

[William \(Bill\) Vaughn]

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.
__________________________________

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:ei**************@TK2MSFTNGP10.phx.gbl...

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
"William (Bill) Vaughn" <bi**************@nwlink.com> wrote in message
news:Oo**************@TK2MSFTNGP09.phx.gbl...

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.

__________________________________

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:Oj******************@TK2MSFTNGP11.phx.gbl...

Anything wrong in posting data via an asp.net page? As it is much simpler.
Regards
"William (Bill) Vaughn" <bi**************@nwlink.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...
> 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.
> __________________________________
>
> "John" <jo**@nospam.infovis.co.uk> wrote in message
> news:uC****************@tk2msftngp13.phx.gbl...
> > 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
> >
> >
> >
>
>