473,807 Members | 2,857 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Q: Remote database connection

Hello,

My database stays in a remote site and I have access it through VPN. I would
like connect my current Windows based Asp.Net application with this database.
What are my options? Can I connect remote database with SqlDataAdaper, will
that be slow? Should I sue Web Services to connect database?

Mar 4 '06 #1
4 1903
The SqlClient library can connect to a remote database just fine - assuming
the necessary ports are open - namely TCP 1433

In your connection string, simply specify the IP address of the database as
the Data Source.

Karl
--
http://www.openmymind.net/

"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:6E******** *************** ***********@mic rosoft.com...
Hello,

My database stays in a remote site and I have access it through VPN. I
would
like connect my current Windows based Asp.Net application with this
database.
What are my options? Can I connect remote database with SqlDataAdaper,
will
that be slow? Should I sue Web Services to connect database?

Mar 4 '06 #2
Thank you very much for the reply. Will there be any performance difference
if I call a web service and let it access the remote database?

"Karl Seguin [MVP]" wrote:
The SqlClient library can connect to a remote database just fine - assuming
the necessary ports are open - namely TCP 1433

In your connection string, simply specify the IP address of the database as
the Data Source.

Karl
--
http://www.openmymind.net/

"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:6E******** *************** ***********@mic rosoft.com...
Hello,

My database stays in a remote site and I have access it through VPN. I
would
like connect my current Windows based Asp.Net application with this
database.
What are my options? Can I connect remote database with SqlDataAdaper,
will
that be slow? Should I sue Web Services to connect database?


Mar 4 '06 #3
hitting the database directly will likely be somewhat faster. web services
aren't particularly quick - they relly on verbose SOAP and XML. Depending
on the application, the difference might not be noticeable.

Karl

--
http://www.openmymind.net/

"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:2C******** *************** ***********@mic rosoft.com...
Thank you very much for the reply. Will there be any performance
difference
if I call a web service and let it access the remote database?

"Karl Seguin [MVP]" wrote:
The SqlClient library can connect to a remote database just fine -
assuming
the necessary ports are open - namely TCP 1433

In your connection string, simply specify the IP address of the database
as
the Data Source.

Karl
--
http://www.openmymind.net/

"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:6E******** *************** ***********@mic rosoft.com...
> Hello,
>
> My database stays in a remote site and I have access it through VPN. I
> would
> like connect my current Windows based Asp.Net application with this
> database.
> What are my options? Can I connect remote database with SqlDataAdaper,
> will
> that be slow? Should I sue Web Services to connect database?
>


Mar 4 '06 #4
Yes. By definition here, the web service acts as a proxy in this scenario,
So there will be a performance hit, but it may not be noticable. You will
need to try it.

--
Terry Burns
http://TrainingOn.net

"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:2C******** *************** ***********@mic rosoft.com...
Thank you very much for the reply. Will there be any performance
difference
if I call a web service and let it access the remote database?

"Karl Seguin [MVP]" wrote:
The SqlClient library can connect to a remote database just fine -
assuming
the necessary ports are open - namely TCP 1433

In your connection string, simply specify the IP address of the database
as
the Data Source.

Karl
--
http://www.openmymind.net/

"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:6E******** *************** ***********@mic rosoft.com...
> Hello,
>
> My database stays in a remote site and I have access it through VPN. I
> would
> like connect my current Windows based Asp.Net application with this
> database.
> What are my options? Can I connect remote database with SqlDataAdaper,
> will
> that be slow? Should I sue Web Services to connect database?
>


Mar 4 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
3046
by: kackson | last post by:
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!!
4
5621
by: GAVO-UK | last post by:
Hello everyone. Using Access 2003 and MSDE I just started experimenting using Access as the front end for SQL using *.adp, and would like to connect the front end to the back end remotely, purely through the internet to a remote computer, hosting the SQL Server (MSDE), but the problem is that I don't know where to start, the only thing I do know is that I have to create a connection string using ADO - OLE DB, something like this
3
2575
by: Hrvoje Vrbanc | last post by:
Hello all! Scenario: - web server at one location (domain) with VS 2003 - SQL server at a remote location (domain) - VPN connection on port 1433 between the two domains I have no troubles reaching the remote SQL server either from SQL Enterprise manager or in VS 2003 design-time (using the SQL authentication in both cases) - all the connections work and I can preview data while building
5
8526
by: Mitya Mitriev | last post by:
Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine. Then I installed application on production server. Database is placed on another server. I received the error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...
10
5800
by: cleo | last post by:
I am migrating from VB6/Access to Visual Basic and SQL Express. I have success writing test code on my local machine and am now setting up tests for deployment to a server. I have installed SQL Express on a Windows 2003 Server. I can connect and create databases on the Remote Server from my local machine using SQL Management Express, so I know Remote Access is working. However, I am unable to connect using a connection string within...
2
2096
by: Tor Inge Rislaa | last post by:
Database on remote server On the remote server where my ASP.NET application is located there is no SQL Server or SQL Server Express. When I test my application locally it works fine because I have the SQL Server Express 2005 on my computer, but when I deploy it I am getting error message telling me that there are some problems connecting to the database. I have done the preparation on my SQL Server to allow remote connection to the...
4
4227
by: Noy B | last post by:
Hi, I have developed a small application that is using a MSAccess DB. the problem is that it was developed on a machine where the application and the DB are both located. now it needs to be change that the application will be able to run on any other machine (using \\ syntax on the run command- not a problem) using the DB located on a static-different machine. for this purpose I need to create a Remote Connection from my
8
2840
by: BD | last post by:
I am developing C# win form app to work with remote database on SQL Server 2005. Problem scenario is as follows: 1. a form is open that has downloaded dataset to local cache 2. computer is put into stand-by or hibernation 3. later, computer is brought out of stand-by or hibernation 4. when trying to save or close form, SQL exception comes up (remote system closed conn) I know this relates to connection pooling, but I am having a...
3
5748
by: Me LK | last post by:
I did a search but could not find an aswer that worked so here it goes. I just did an upgrade from 2003 to vs 2005 express. I am using a remote sql server 2000. I specifically upgrade to make use of the login control. Everything upgraded fine and the site is working on my local machine. It seems that my site is trying to connect to a local database. I need it to attach to a remote database. I added a connection string to
5
3563
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting this error. Any idea why? Server Error in '/myuser4/MyWebApp' Application. --------------------------------------------------------------------------------
0
9720
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9599
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10372
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10374
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7650
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6879
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5685
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4330
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3854
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.