//数据库测试连接
public DBConnTestResultModel DBConnTest(DBConnTestModel dbModel)
{
DBConnTestResultModel returnRes = new DBConnTestResultModel();
DBObject db = null;
if (dbModel.DBDrive == "SqlServer2005" || dbModel.DBDrive == "MySql")
{
if (dbModel.DBCreateNew == true)
{
//尝试新建数据库
string str = "Data Source=" + dbModel.DBServer + ";" + "Initial Catalog = master;" + "User id=" + dbModel.DBUserID + ";" + "Password="******"CREATE DATABASE " + dbModel.DBName;
try
{
Comm.ExecuteNonQuery();
}
catch
{
returnRes.res = "尝试建立新数据库失败，请检查配置是否正确";
return(returnRes);
}
//测试成功则可以返回
db = CreateDBObject(dbModel.DBDrive, dbModel.DBServer, dbModel.DBName, dbModel.DBUserID, dbModel.DBPassWord);
returnRes.db = db;
returnRes.res = "数据库连接成功";
return(returnRes);
}
}
}
db = CreateDBObject(dbModel.DBDrive, dbModel.DBServer, dbModel.DBName, dbModel.DBUserID, dbModel.DBPassWord);
if (db.DbDrive != DBDrive.Oracle)
{
if (dbModel.DBCreateNew)
{
if (db.TestConnection(false))
{
returnRes.res = "数据库已经创建";
}
if (!db.NewMasterDBObject().TestConnection(false))
{
returnRes.res = "连接失败，请检查配置是否正确(或检查是否勾选“新建数据库”)";
}
returnRes.res = "数据库连接成功";
}
}
if (!db.TestConnection(false))
{
returnRes.res = "连接失败，请检查配置是否正确(或检查是否勾选“新建数据库”)";
}
else
{
returnRes.res = "数据库连接成功";
}
returnRes.db = db;
return(returnRes);
}
