Querys with multiple ODBCs???

[olemma]

Is it possible to construct a sql statement using multiple ODBC connections? Let's say, in C++, how could this be accomplish?

 

[moonshadow]

If your talking about joining data together from several different database servers, have a look at linked servers in SQL Server Books Online

 

[olemma]

Thank you. I do this a lot, but now I am trying joining data from a SQL server and dbf tables. Is this actually possible?

 

[moonshadow]

We did it with an MS Access table today. If this an OLEDB driver for it, it should be possible

 

[moonshadow]

If you can use it as a linked server, you might be able to use OPENROWSOURCE