You can currently connect to SQL Azure using ODBC or OLEDB. See my post in the help forum. However, it would be nice to be able to connect using the "SQL" login.
If you try to login with SQL method, you can't select the starting database, so it starts in "master" database. Attempt to switch database throws exception. Would be nice to investigate issue and tweak/fix it so it works with Azure.