I have an ActiveX Script task that uses recordset to open up a table within a database. To facilitate not having to go to all my packages and edit the connection strings, I want to use a UDL file that stores the connection string...this way I only have to change the UDL file when going to Production stage. When opening a recordset, how can I reference the recordsets connection properties to look at the connection string in the UDL file? Is it even possible? Any other ideas? Thanks a bunch.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using a UDL file for the connection of a recordset
- Thread starter rmchung
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question