Question

用DW连接SQL数据库，成功创建连接却找不到表

我用的是dw8+MSSQL2000,都提示成功创建连接脚本了，但是却找不到表，高手请详细说明下原因和解决方法，不知道的不要到处去复制些不相关的来

Answer 1

const DB_SERVER = "(LOCAL)\GSQL"'"202.67.237.244" '数据库服务器名
const DB_DATABASE = "数据库名" '数据库名
const DB_UID = "sa" '数据库登录账号
const DB_PWD = "" '数据库登录口令

CONNECTION_STRING = "driver={sql server};UID=" & DB_UID & ";PWD=" & DB_PWD & ";Database=" & DB_DATABASE & ";server=" & DB_SERVER & ";"

function OpenDB(strConn,conn)
set conn = Server.CreateObject("ADODB.Connection")
conn.CursorLocation = 3
conn.ConnectionTimeout = 180
conn.commandtimeout = 180
conn.Open strConn
end function

'用这个调用链接就行了
OpenDB CONNECTION_STRING,conn

Answer 2

按照以下三步做（也可使用DataSet）：

/// <summary>
/// 执行select简单sql语句返回数据阅读器的方法
/// </summary>
/// <param name="sql">传入的sql语句</param>
/// <returns>SqlDataReader</returns>
public static SqlDataReader ExecuteReader(string sql)
{
SqlConnection conn = new SqlConnection("server=.;database=HotelManager;uid=sa;pwd=123456");//服务器名，数据库名，用户名及密码根据具体情况而变

SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
return cmd.ExecuteReader();
}
catch
{
return null;
}
}

/// <summary>
/// 类中通用的查询数据方法
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns></returns>
private List<Room> QueryDataBySql(string sql)
{
List<Room> lst = null;
SqlDataReader sdr = DBUtility.SqlHelper.ExecuteReader(sql);
if (sdr != null)
{
lst = new List<Room>();
while (sdr.Read())
{
Room model = new Room();
model.Id = (int)sdr[0];
model.Number = (string)sdr[1];
model.BedNumber = (int)sdr[2];
model.Descrip = (string)sdr[3];
model.State = sdr.GetString(4);
model.GuestNum = (int)sdr["GuestNum"];
model.TypeId = (int)sdr["TypeId"];

lst.Add(model);
}
sdr.Close();
}
return lst;
}

/// <summary>
/// 查询Rooms表中所有记录的方法
/// </summary>
/// <returns>List<Room></returns>
public List<Room> Select()
{
string sql = "select * from Rooms";

return QueryDataBySql(sql);
}

Answer 3

我是看教程给你的，我没用过sql数据库