SQL Server 2000 connecting to .net 1.1
Posted on 2007-12-03
How to start SQL Server 2000 and use it for .net application.
i have used SQL connection as
SqlConnection connection = new SqlConnection("Data Source=LOCAL;DataBase=ecomm;User ID=sa;Password=comt");
string strSelect = "SELECT productname FROM walts WHERE productid='" + TextBox1.Text + "'";
SqlCommand cmd = new SqlCommand(strSelect, connection);
I have an error at connection.Open() saying
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
i am using .net1.1/c#/sql server2000.