I am trying to connect to a multiple database at the same time how can I do it ?

You'll have to create different Connections using different connection strings for this to work. You'll end up with isolated recordsets that you can't combine or connect to each other.

Other than that, things will work the way they work with one connection for one database.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I thought it was possible to perform a union query across two different databases.

Not directly from an ASP page, AFAIK.

What you could do in SQL Server is connect to multiple Servers / Databases from within a Stored Procedure. Is that what you're referring to?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

A database query to an MS-SQL server database can call two databases in either a straight text query or from within a stored procedure as long as the two databases reside on the same server. If the databases are on two different database servers then you have to apply some additional techniques like linked servers.

The query you use must simply reference the other database explicitly:

SELECT t1.field, t2.field
FROM Database1..Table AS t1, Database2..Table AS t2

Peter
------------------------------------------------------
Work smarter, not harder.

can you please explain how your code works Peter