读书人

C#连接SQL2000 有关问题

发布时间: 2012-01-30 21:15:58 作者: rapoo

C#连接SQL2000 问题
string connStr,selectCmd;
connStr = "Server=localhost;database=dbTest;uid=sa;pwd=8630104; ";
selectCmd = "select * from tbTest ";
SqlConnection conn;
SqlCommand cmd;
SqlDataReader reader;

conn = new SqlConnection(connStr);
conn.Open();
cmd = new SqlCommand(selectCmd,conn);

SQL2000的密码已经设为8630104,默认的数据库也是dbTest,但为什么连接不上呢?cmd = new SqlCommand(selectCmd,conn);报错!
请高手指点,谢谢!

[解决办法]
cmd = new SqlCommand(selectCmd,conn);报错!
============================================
报什么错?


Server=127.0.0.1 试一下
[解决办法]
OleDbConnection myConnection = new OleDbConnection(ConnStringDB);
OleDbCommand myCommand = new OleDbCommand(ListString,myConnection);
myConnection.Open();
OleDbDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.

while (myReader.Read())
{

}
myCommand.Dispose();
// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
myConnection.Close();


[解决办法]
Server=localhost


server=服务器名称或IP试试
[解决办法]
connStr = "Server=localhost;database=dbTest;uid=sa;pwd=8630104; ";

改为

connStr = "Server=(local);database=dbTest;uid=sa;pwd=8630104; ";

[解决办法]
server=(local)
[解决办法]
连接串 Server =(local)

读书人网 >C#

热点推荐