Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Number of connection to Linked Server

 
   Database Help (Home) -> ODBC RSS
Next:  SSIS Feed to Oracle Sending Blank Rows  
Author Message
-pb-

External


Since: Oct 14, 2008
Posts: 2



(Msg. 1) Posted: Tue Oct 14, 2008 6:00 am
Post subject: Number of connection to Linked Server
Archived from groups: microsoft>public>sqlserver>odbc (more info?)

Hi,

Following is our different database infrastructure.

Server1 on NetwrokDomain1
SQL Server 2000
Server2 on NetwrokDomain2
SQL Server 2000

The database on Server2 is being used by third party clients and
database on Server1 is used by us.

We want to get information from databases on Server2 on Server1. To
accomplish this, we had created a Linked Server Connection on Server1
to Server2 and created certain views on Server1 which then used within
SPs on Server1. The requests are coming from Web application by many
user to Server1.

Does anyone got any idea on how many number of connection will be
created between Server1 and Server2 per request? Will there be
different connection created for each request or it will utilise the
same connection (connection created while creating the linked server)?

It would be very helpful if anyone can point me to a correct
direction.

Any help is appreciated.

Thanks

-pb-

 >> Stay informed about: Number of connection to Linked Server 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to Tell if My ODBC Connection is to a SQL Server? - What is the usual manner to detect if my ODBC connection (based on a DSN) is connected to an instance of SQL Server (including a specific version of SQL Server such as 2005), as opposed to other RDBMSes such as Oracle, DB2, etc? Are we talking..

Connection Error using SQL Server ODBC - Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in the Machine name, but it won't let me connect. Where the wizard asks me what the server name is that I want to connect to, the drop down is empty. I thought it should show me...

odbc connection hangs jobs on one server but not another - I have two sql servers and one aix/unix server. server 1 - windows 2003 r3 running Microsoft SQL Server 2000 - 8.00.760 build 3790 server 2 - windows 2000 sp 4 running Microsoft SQL Server 2000 - 8.00.760 build 3790 server 3 - aix - unix running a...

Connection to SQL Server failed using Excel 2007 - We have Excel 2007 spreadsheets that are connected to Queries in Access 2007, in turn the Queries in Access have link tables to an SQL Server. The SQL Server requires the user to login with a user-id and password. In previous versions of Access and..

error message in view to a linked server - Hello, I have a firebird 1.5 application. In my sql-server 2000 I created a linked server to firebird using the firebird odbc driver. I cannot query one table because I get the following error: " [Non-interface error: Column 'ERHALTENABSCHLAG'....
   Database Help (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]