TMD,我老是写错OLeDB连接的字符串的,还是写在自己的Blog上纪念一下我的失忆症: 本地测试: System.Data.OleDb.OleDbConnection conn = new OleDbConnection( " Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sqlser帐户;Password=sqlserver密码;Initial Catalog=数据库名称;Data Source=CP1897-BRYAN;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CP1897-BRYAN;Use Encryption for Data=False;Tag with column collation when possible=False; " ); conn.Open(); if (conn.State == System.Data.ConnectionState.Open) ... { Response.Write("Open"); conn.Close(); } else ... { Response.Write("close"); } 远程连接: private static string DefaultCDBConnectionString = @" Provider=SQLOLEDB.1;Data Source=IP地址,1433;Network Library=DBMSSOCN;Initial Catalog=数据库名称;User ID=sqlserver帐号;Password=sqlserver密码; " ;