I have to amend one of my projects so that it uses ADO instead of DAO. I need to connect via a DSN, but I want to create it in code. I usually do it with DBEngine.RegisterDatabase, but is there another way I can do it so that I do not have to add DAO references into my project?

Also how do I check if a DSN exists (apart from trying to connect to the DB and testing if it has suceeded)?

All help greatly appreciated!!