Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello community,
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..
I sounds like a bug... Did you try to put the command
disconnect;
before trying to connect to another database? it should be optional but since you have a problem... this command must exist for some reason...
Regards,
Erich
Hi
Yes it possible to connect several database in one document.
Eg-
connection string for databade1
select * from tablename1
select * from tablename2
connection string for databade2
select * from tablename21
select * from tablename22
connection string for databade3
select * from tablename31
select * from tablename32
Regards
Sonu Srivastava
thanks for your reply,
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.
best regards
mehmet caldak
I sounds like a bug... Did you try to put the command
disconnect;
before trying to connect to another database? it should be optional but since you have a problem... this command must exist for some reason...
Regards,
Erich
thank you Erich,
disconnect command solved my problem..
You mean you had to disconnect afte each connect?
I believe the sequence is something like this:
- Connect to DB1
- Extract table 1 from DB1
- Extract table n from DB1
- Disconnect from DB1
- Connect to DB2
- Extract Table x from DB2
Usually, you don't need the disconnect command.
Best Regards,
Erich