change connection string

[TjS]

how do i change a connection string from passthrough query;
i have about 100 passtrhough querys with of course a connection to a databse (oracle). With one button in a form i want to be able to change the connection to another database (oracle).

Thanks for the reply!

 

[Guus2005]

use the connect property of the query.

qdf.connect

 

[KeithG]

Open up the query in a querydef object and use the connection string property

 

[TjS]

uhm..ok, thanks....
but my problem is how to put it in code...

 

[Guus2005]

Half of the code is already here.
You have to loop through all the queries and change the connect property.
That's it!