新手请教如何访问局域网内的sql sever数据库，流程越详细越好
新手请教如何访问局域网内的sql sever数据库，流程越详细越好 问题点数：50、回复次数：4Top
1 楼COKING（天晴）回复于 2004-08-01 21:27:44 得分 0
看来你还不知道ADO吧！
就让楼下的告诉你吧！！ 我在外面！Top
2 楼dhfly（飞鸿）回复于 2004-08-02 00:06:58 得分 20
用ADO控件的ConnectionString属性设置(有向岛）
如果事AdoTable,再设号TableName
如果是AdoQuery，设好Sql属性
然后在运行的时候设置Active属性为trueTop
3 楼ralpha08（被水淹死的鱼）回复于 2004-08-02 00:19:57 得分 30
//连接ADOCONNECTION
String ls_var;
path.SetLength (MAX_PATH) ;
path.SetLength (GetSystemDirectory (path.c_str (), path.Length ())) ;
if (!FileExists(path+".\\Con.ini"))
{
MsgWarning("Con.ini文件不存在!");
return;
}
String UserID,PassWord,AliasName,DBName,VP_ServerName;
TIniFile * ini;
ini = new TIniFile(path+".\\Con.ini");
AliasName=ini->ReadString( "数据库登录","用户别名","");
DBName=ini->ReadString( "数据库登录","数据库名","");
UserID=ini->ReadString( "数据库登录","用户名称","").Trim();
PassWord=ini->ReadString( "数据库登录","用户口令","");
VP_ServerName=ini->ReadString("服务器信息","服务器名","");
delete ini;
String ConnStr = "Provider=SQLOLEDB.1;Password=%S;"
"Persist Security Info=True;User ID=%S;"
"Initial Catalog=%S;"
"Data Source=%S"
;
ConnStr = Format (ConnStr,
ARRAYOFCONST((
(String)PassWord,
(String)UserID,
(String)DBName,
(String)VP_ServerName
))
);
ADOConnection1->Close();
ADOConnection1->ConnectionString = ConnStr;
try
{
ADOConnection1->Open();
}
catch(Exception&e)
{
ShowMessage("初始化数据库失败!"+e.Message);
return;
}
//这是从系统目录读取Con.ini文件动态连结数据库的例子Top
4 楼Fow（含笑半步颠）回复于 2004-08-02 08:03:44 得分 0
顶一下！！Top
