Asynchronous commands in ADO.NET Whidbey

If you are playing with ADO.NET in Whidbey, this little piece of information is for you.  If you want to use the asynchronous commands and you are running your code on the same system and your Sql Server database, you will want to use the TCP/IP protocol to communicate with your database.  This means that you could specify the data source as an IP Address or localhost, but don't specify the database as (local) or machine name.  Opening a connection will generate an error with the message: Shared Memory Provider:Asynchronous operations not supported.  This took forever for me to figure out.  I was finally able to figure it out from the semi-private Whidbey newsgroups.

Wally