Connecting to MSDE using the SQL Adapter

Well, I find myself replying to my own bloomin' e-mail. Just so that nobody else has to gho through the pain that I have, here is the result. You need the 'pubs' and 'Northwind' DB's to run the examples - the DB's mentioned come only with SQL and not MSDE - VB.NET will connect to MSDE and not SQL... ...so... I'm not going to go through the whole process, but in your Enterprise Manager, you can create a new empty DB called 'pubs' and 'Northwind'. You can then import the data from the SQL DB's to create a duplicate. One word of warning, when importing the data, select to 'Copy Objects' and then change the options to 'Copy SQL Server Logins'. The rest should be left as default. Voila! At least you'll get an early night - I didn't!