multiple conn strings?

[Anonymous]

Hi experts,

i am creating qvd

i am loading data from 2 different data sources for example

odbc to oracle;

odbc to sql server;

and here i have one table from odbc to oracle  connection and another from  odbc to sql server

but when i go for reload it is talking last connection string only ?

i want this application should connect to both database and while reloading it should not give any error?

[Anonymous]

Hi,

load both the databases and store them in QVD files. Then, I load both QVD (which is quite fast) in the same table.

Although for clearer code you may use the CONCATENATE keyword

Regards

Sagar

[Anonymous]

Hi,

You will only have one connection open at any time.

Connect to source A and load required tables, then connect to source B and load required tables.

You can always re-connect to source A later in the script if required for additional data loading using a new connection string.

[Anonymous]

can any one give sample script

[rajeshvaswani77]

Hi,

You can do it this way.

Connection string 1

.

Code / SQL related to tables in connection 1 here

.

.

Connection string 2

.

.

Code / SQL related to tables in connection 2 here

thanks,

Rajesh Vaswani

[#6]

Hi,

try this.

Connection odbc to oracle

load *

table.

Store into QVD;

Connection odbc to sql server

load *

table

Store into QVD;

Regards,

Chennaiah

[#7]

you cannot connect multiple databases at a time.

connect to oracle

select * from tablename

disconnect;

connect to sql server

select * from tablename

disconnect;

and so  on....