is it possible to connect several databases in the same document?
i'm trying to create a qvw document which has more than one OLEDB or ODBC connection, in one tab PervasiveSQL and in another tab MsSQL Server and in the other tab Oracle11g . actually it works when just connects with PervasiveSQl and MsSQL Server but when i try to add an OLEDB connection through Oracle OleDb Provider it fails. can you tell me if i am on the wrong way or it is possible but i couldnt achieve..
surprisingly Qv(10 SR1) react differently depending on connections order. when first connect to MsSQL Server then cannot connect the other databases. at every time try connect to another DB, MsSQL connections window appear and doesnt allow making connections. on the contrary, when i reverse the connections order putting MsSQL connection to end it works fine. i wonder why it does such a thing.