Inserting into SQL Server

[VJ]

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.

 

[Paul Clement]

¤ 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.

See if the following helps:

http://geekswithblogs.net/ranganh/archive/2005/05/25/40489.aspx


Paul
~~~~
Microsoft MVP (Visual Basic)