connection strings with ado

[DTSFreak]

Hi,

I was wondering how i could set connection strings from info in a table.

I have a table where i store the following data about connections:

Id
DataProvider
NetworkLibrary
DataSource
PortNr
Database
UID
PWD (don't know if i should store that in a table)

Also i have forms which get their recordsets from several databases. So i
want to adjust my ado connection function to use different connections by
getting the connection info from my table.

How can i do this?

 

[cmmrfrds]

I can't think of anything that would prevent you from building the connection string from the components in the table.