Get data from two different servers with two threads

Mark

our asp.net application needs to retrieve data from two different database
servers - one is Informix the other is SQL Server. I'd love to send out
both requests at the same time, rather than waiting for the first to get
back to me before calling the second. Where could I find a short code
sample on how to leveraging threading and/or asynchronous calls for this?
Are there general issues I should be aware of in going down this road? In
both cases, the data will be read-only.

Thanks in advance.

Mark

Nov 18 '05 #1

Subscribe Post Reply

1339

Raghavendra T V

hi,

may be you can search for sample scripts on Linked servers if i am not
wrong.

Thanks
Raghavendra
"Mark" <fi******@idonotlikejunkmail.umn.edu> wrote in message
news:e7**************@TK2MSFTNGP09.phx.gbl...

our asp.net application needs to retrieve data from two different database
servers - one is Informix the other is SQL Server. I'd love to send out
both requests at the same time, rather than waiting for the first to get
back to me before calling the second. Where could I find a short code
sample on how to leveraging threading and/or asynchronous calls for this?
Are there general issues I should be aware of in going down this road? In
both cases, the data will be read-only.

Thanks in advance.

Mark

Nov 18 '05 #2

Juan Romero

Please see documentation for the system.Threading namespace and the
system.Threading.Thread class.

"Mark" <fi******@idonotlikejunkmail.umn.edu> wrote in message
news:e7**************@TK2MSFTNGP09.phx.gbl...

our asp.net application needs to retrieve data from two different database
servers - one is Informix the other is SQL Server. I'd love to send out
both requests at the same time, rather than waiting for the first to get
back to me before calling the second. Where could I find a short code
sample on how to leveraging threading and/or asynchronous calls for this?
Are there general issues I should be aware of in going down this road? In
both cases, the data will be read-only.

Thanks in advance.

Mark

Nov 18 '05 #3

bruce barker

async would be a better answer, but there is no async support yet. if you
have a busy site, you may want to implement a thread pool, or a least a
thread quota. another issue will be that thread have the security content of
the process not the creating thread, so you will need to implement some
impersonation logic if you use trusted connections.
-- bruce (sqlwork.com)
"Mark" <fi******@idonotlikejunkmail.umn.edu> wrote in message
news:e7**************@TK2MSFTNGP09.phx.gbl...

our asp.net application needs to retrieve data from two different database
servers - one is Informix the other is SQL Server. I'd love to send out
both requests at the same time, rather than waiting for the first to get
back to me before calling the second. Where could I find a short code
sample on how to leveraging threading and/or asynchronous calls for this?
Are there general issues I should be aware of in going down this road? In
both cases, the data will be read-only.

Thanks in advance.

Mark

Nov 18 '05 #4

by: djc | last post by:

I need to use data from multiple tables that are located in 2 different databases. Most of the tables are in SQL Server 2000 but 1 one the tables I need to include in my query resides in an...

ASP / Active Server Pages

Create view with data from multiple servers

by: Ringo Langly | last post by:

Hi everyone, I have 5 servers, all with identical databases just different data. I have a rather lengthy SQL statement (in a View) to hit one database and pull-in certain data, but I'd like to...

Microsoft SQL Server

Async Socket: How to tell when there is no more data.

by: mscirri | last post by:

The code below is what I am using to asynchronously get data from a PocketPC device. The data comes in fine in blocks of 1024 bytes but even when I send no data from the PocketPC constant blocks of...

C# / C Sharp

Help with first VB application - Data Entry form

by: Timothy.Rybak | last post by:

Hello all, This is my first attempt at an application, so kid gloves are appreciated. I need to make a very simple form that only has a few elements. One is TraceCode - a text field that is...

Visual Basic .NET

Want form to show changing data. But it could be closed, or closing, during update.

by: Zytan | last post by:

I have public methods in a form. The main form calls them, to update that form's display. This form is like a real-time view of data that is changing. But, the form may not exist (it is...

C# / C Sharp

what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored procedure is executed by sql server 2005 then it creates 10

by: DR | last post by:

what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored...

C# / C Sharp

Please help explain what an "application instance" really is in terms of static data

by: Dave | last post by:

I have a global.asax file with Application_Start defined and create some static data there and in another module used in the asp.net application and I realize that static data is shared amongst...

ASP.NET

Publishing Access Data on the Web

by: ADezii | last post by:

There are essentially three techniques for publishing Access Data on the Web. The first technique is static, and does not allow for the dynamic addition or modification to the data, There is no...

Microsoft Access / VBA

converting char to float (reading binary data from file)

by: itdevries | last post by:

Hi, I'm trying to convert some char data I read from a binary file (using ifstream) to a float type. I've managed to convert the int types but now I need to do the float types as well but it...

C / C++

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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

General

Changing the language in Windows 10

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

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Get data from two different servers with two threads

Similar topics