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

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

Thu, 12 May 2011 11:50:49 GMT

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

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

Thu, 12 May 2011 12:21:08 GMT

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

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

Fri, 13 May 2011 14:13:58 GMT

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

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

erichshiino — Fri, 13 May 2011 14:18:49 GMT

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

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

Fri, 13 May 2011 14:52:13 GMT

thank you Erich,

disconnect command solved my problem..

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

felixobes — Sun, 09 Feb 2014 23:58:54 GMT

You mean you had to disconnect afte each connect?

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

erichshiino — Wed, 05 Mar 2014 12:38:15 GMT

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