Changing data connections for a Recordset DTC?

[jimster]

I have an ASP page with a Recordset DTC and a Grid DTC on it. I have set up three Data Commands to three separate Access databases, through the Data Environment. If I set the command details for the Recordset DTC through its property pages, the grid is populated.

However, I am passing a string to the page and I want to be able to change the connection and SQL text for the Recordset DTC at run-time depending on the string. Is this possible without having to use three separate Recordset DTCs.

Cheers

 

[palbano]

jimster,

Look at the Recordset.onbeforeload() event. You can set the SQLText property of the Recordset in that event.

I've never tried changing the connection property but that should work as well.

Good luck
-pete