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

is ASP the only way for SQL remote access via internet

P: n/a
Hi.
I would like to access my database outside of my company. I read many
documents but they are all pertaining to accessing the database via
ASP or some form of web application. Is there no single windows or
linux application tht runs natively to access a remote SQL data base?
Any advise is appreciated. Thanks!!
Jul 20 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
The only requirement for an application to access a remote SQL Server is
network connectivity. There are additional considerations with remote
client-server access, such as security, deployment complexity and
performance. These are reasons why a web-based architecture is most often
chosen for remote data access.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kackson" <ka*****@yahoo.com> wrote in message
news:90**************************@posting.google.c om...
Hi.
I would like to access my database outside of my company. I read many
documents but they are all pertaining to accessing the database via
ASP or some form of web application. Is there no single windows or
linux application tht runs natively to access a remote SQL data base?
Any advise is appreciated. Thanks!!

Jul 20 '05 #2

P: n/a
aaj
I suppose you could set up a VPN to your server and use an access ADP
project on the local machine to connect
"kackson" <ka*****@yahoo.com> wrote in message
news:90**************************@posting.google.c om...
Hi.
I would like to access my database outside of my company. I read many
documents but they are all pertaining to accessing the database via
ASP or some form of web application. Is there no single windows or
linux application tht runs natively to access a remote SQL data base?
Any advise is appreciated. Thanks!!

Jul 20 '05 #3

P: n/a
Hi.
What exactly is access ADP? If I setup a VPN, is this "access ADP" the
only best secure method? Are there alternatives that are secure and
proven to be the sort of industry standard method (the way that most
people do) where native applications (not via net applications) access
databases over internet? Any advise is really much appreciated.
"aaj" <a.*@c.com> wrote in message news:<40**********************@news.easynet.co.uk> ...
I suppose you could set up a VPN to your server and use an access ADP
project on the local machine to connect
"kackson" <ka*****@yahoo.com> wrote in message
news:90**************************@posting.google.c om...
Hi.
I would like to access my database outside of my company. I read many
documents but they are all pertaining to accessing the database via
ASP or some form of web application. Is there no single windows or
linux application tht runs natively to access a remote SQL data base?
Any advise is appreciated. Thanks!!

Jul 20 '05 #4

P: n/a
> What exactly is access ADP?

An ADP is a Microsoft Access project file that uses SQL Server as the
underlying database engine.
If I setup a VPN, is this "access ADP" the only best secure method?
An ADP is basically just a client application. It is the VPN connection
that provides the secure network connection needed for a client-server
application to use a remote database over the public internet.

Although you can run the application locally and access the remote database
over a VPN connection, another common method is to establish a remote
desktop connection over a VPN to an application server and run the app
there. Like a web app, this can reduce network overhead and facilitate
deployment.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kackson" <ka*****@yahoo.com> wrote in message
news:90**************************@posting.google.c om... Hi.
What exactly is access ADP? If I setup a VPN, is this "access ADP" the
only best secure method? Are there alternatives that are secure and
proven to be the sort of industry standard method (the way that most
people do) where native applications (not via net applications) access
databases over internet? Any advise is really much appreciated.
"aaj" <a.*@c.com> wrote in message

news:<40**********************@news.easynet.co.uk> ...
I suppose you could set up a VPN to your server and use an access ADP
project on the local machine to connect
"kackson" <ka*****@yahoo.com> wrote in message
news:90**************************@posting.google.c om...
Hi.
I would like to access my database outside of my company. I read many
documents but they are all pertaining to accessing the database via
ASP or some form of web application. Is there no single windows or
linux application tht runs natively to access a remote SQL data base?
Any advise is appreciated. Thanks!!

Jul 20 '05 #5

P: n/a
aaj
As Dan says, an ADP is the Microsoft Access (I think Access 2000 onwards)
front end i.e. the forms etc, but it doesn't use the jet backend, instead it
connects to the SQL Server.

The VPN provides a local IP address on the remote machine that the ADP can
connect to and points it in the direction of the database. I imagine (but
I'm not certain) that any other from end could make a similar connection
e.g. enterprise manager

I suppose bot the VPN and Access are industry standard, but I'm not sure
this type of configuration would be. The only reason we did it like this was
just to see if we could.

I imagine (and I think is what Dan alludes to further down) that using
something like Citrix or terminal server to connect to whatever you use to
access your SQL Server may be a more sensible option.

hope this helps

Andy
"Dan Guzman" <da*******@nospam-earthlink.net> wrote in message
news:jr*****************@newsread2.news.pas.earthl ink.net...
What exactly is access ADP?
An ADP is a Microsoft Access project file that uses SQL Server as the
underlying database engine.
If I setup a VPN, is this "access ADP" the only best secure method?


An ADP is basically just a client application. It is the VPN connection
that provides the secure network connection needed for a client-server
application to use a remote database over the public internet.

Although you can run the application locally and access the remote

database over a VPN connection, another common method is to establish a remote
desktop connection over a VPN to an application server and run the app
there. Like a web app, this can reduce network overhead and facilitate
deployment.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kackson" <ka*****@yahoo.com> wrote in message
news:90**************************@posting.google.c om...
Hi.
What exactly is access ADP? If I setup a VPN, is this "access ADP" the
only best secure method? Are there alternatives that are secure and
proven to be the sort of industry standard method (the way that most
people do) where native applications (not via net applications) access
databases over internet? Any advise is really much appreciated.
"aaj" <a.*@c.com> wrote in message

news:<40**********************@news.easynet.co.uk> ...
I suppose you could set up a VPN to your server and use an access ADP
project on the local machine to connect
"kackson" <ka*****@yahoo.com> wrote in message
news:90**************************@posting.google.c om...
> Hi.
> I would like to access my database outside of my company. I read many > documents but they are all pertaining to accessing the database via
> ASP or some form of web application. Is there no single windows or
> linux application tht runs natively to access a remote SQL data base? > Any advise is appreciated. Thanks!!


Jul 20 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.