Async commands work with 64 bits
I just did some async stuff in Whidbey to a Sql2k Server running on a remote machine. The remote server is running Win2k with Sql2k (both 32 bit) on it. It works! Yippee!
Here is the code:
using System.Data.SqlClient;
...........
private SqlCommand sqlCm = null;
...........
string strCn = "data source=.....favorite server.....;initial catalog=dbWhidbey;User Id=.....favorite user id......;Password=.....favorite value.....";
string strSql = "insert into tblTest ( Setting, Value ) values ('Test1', '64 bits')";
sqlCm = new SqlCommand();
SqlConnection sqlCn = new SqlConnection();
sqlCn.ConnectionString = strCn;
sqlCm.Connection = sqlCn;
sqlCm.CommandText = strSql;
sqlCm.CommandType = CommandType.Text;
sqlCn.Open();
sqlCm.BeginExecuteNonQuery();