.net与sql server连接问题(在线等待)

Question

string strConn="server=192.168.0.5;database=Realty;uid=sa;pwd=54321;Max Pool Size=20";
SqlConnection conn = new SqlConnection(strConn); try
{
conn.Open();
}
catch
{
conn = null;
}

Answer 1

连接字符串：
 SqlConnection (.NET) 
 Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" 
 Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;" 
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
 Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;" 
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
 Declare the SqlConnection:C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open(); VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open() 

Answer 2

http://www.csdn.net/Develop/read_article.asp?id=16437

Answer 3

http://www.csdn.net/Develop/read_article.asp?id=16437

Answer 4

真的不好意思,我只懂asp.net,有时我想是不是odbc配错了