Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

is it possible to connect several databases in the same document?

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.. 

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

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

View solution in original post

6 Replies
Not applicable
Author

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

Not applicable
Author

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

erichshiino
Partner - Master
Partner - Master

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

Not applicable
Author

thank you Erich,

disconnect command solved my problem..

felixobes
Contributor III
Contributor III

You mean you had to disconnect afte each connect?

erichshiino
Partner - Master
Partner - Master

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