Creating DSN in code

[Stevie]

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!! :)

[Serge]

Check your Other Post (http://forums.vb-world.net/showthread.php?threadid=12943)