I must create a query to read data on two database (db1 - db2)
on db1 I have the table "customers" with "cod-customer","cust-name " ...
on db2 I have the table "dossier" with "cod-customer" .

I must create a query to read tables dossier and customers where
dossier.cod-customers = customers.cod-customer and read the cust-name

which is code to open database connect with two database on one command?
Help me
Ciao

Are these databases on the same DB server? What is the DBS platform?
In MS-SQL you can easily work between databases using the syntax
<database>..<tablename>
I don't know about other platforms.

This is usually the easier way to do it, but in ADO with a dataset, you can open several tables, then build relationships between them without (I believe) the need to have those tables residing in the same DB, DB server or even the same format (one from DB, one from XML). As long as there are datatypes that can be tied together in some form of relation.

Peter

Hello Peter,
DBS platform is Progress, it is 4GL database, and my database is multivolume. To connect odbc.net with two database I using two
DNS files odbc drive. These databases are on the same DB server.
I cannot insert two dns on ODBC.net parameter connection.
Ciao
Peter
Grazie

I have never worked with that DB, and don't deal with ODBC much. 99.9% of the time I'm on MS-SQL and use the System.Data.SQLClient classes for connection. You'll have to look into the syntax of that DB system to see if you can query across DBs. I'd be surprised if you couldn't. If you can't, then you'll need to look into more advanced ADO.Net functionality.

Peter