Inserting into SQL Server



This is the first time I've tried this...
I've got this syntax:

void Page_Load(Object src, EventArgs E) {
string connectionStr =
@"server=111.111.111.111;uid=DDATA/web;pwd=web;trusted_connection=true;d
atabase=events";
string insertQuery = "Insert into Events VALUES " +
"('"+Session["Name"]+"', '"+Session["Phones"]+"')";
SqlConnection connectObj = new SqlConnection(connectionStr);
SqlCommand commandObj = new SqlCommand(insertQuery, connectObj);

commandObj.Connection.Open();
commandObj.ExecuteNonQuery();
commandObj.Connection.Close();
}

The error message I get is this...
Login failed for user '(null)'

I have two application servers DDATA (111.111.111.111) AND DWEB on the
same DOMAIN...
I'm trying to use an insert statement (confirm.aspx) on DWEB into a sql
server DDATA.

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com
.