>>Paul,
>>
>>Thanks for the input. Actually I had the enum in there, but I pulled it because I think I'm going to do an enaum for DB type, SQL, Access, MySql, ect, then determine internally which provider to use. I will also dynamically configure the connection string.
>>
>>This way, all I have to do is set DBType, ServerName, DBName, UserName and Password and the class will do the rest.
>>
>>What do you think?
>>
>
>Sounds reasonable to me. One thing you might also want to consider supporting is integrated authentication (eg. no username/password is passed, it authenticates using the current users credentials).
Do you know if you can specify encrypt = 'yes' in connection string with integrated security? I got some strange error when I tried to add it into my connection string.
If it's not broken, fix it until it is.
My Blog