Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
erich_shiino
Honored Contributor

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

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

6 Replies
Not applicable

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

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

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

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

erich_shiino
Honored Contributor

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

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

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

thank you Erich,

disconnect command solved my problem..

felixobes
New Contributor

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

You mean you had to disconnect afte each connect?

erich_shiino
Honored Contributor

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

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