hi,
i have two databases MS access and DB2, both have many tables. In a scenario i need to fetch the record from two tables(one table belongs to db2 and other one is from MS access) I have created the Link for DB2 table in MS Access(i.e - In MS access view we can see the db2 linked table).
Now i want to run the query for two tables,My query will be like this,
"select table1.col1,table2.col2 from table1 , table2 where (db2)table1.column1 = (MS access)table2.column1.
i have two different connection strings as well for each databases.
DB2 - connection string has some userid and password.
Ms access - also has its own connection strings.
I have used Ms access database connection strings, and used ODBCCommand(), when i try to execute my query in .net application it prompted me with DB2 user name and password.
how to get the result for the above query.....?
Thanks
Mani