Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000 Vol.17 No.3 P.101-102




ݹܵʵֹԴ
ʯ
ժҪݿϵͳʵ⣬ҵϵͳԴĹ⼰ʵַϵͳľʵʩݹܵӦá
ؼʣҵ ݿϵͳ ODBC ݹܵ
ڽдݿϵͳ뿪ʱΣûѾʹĳЩרõҵʹһЩԼСϵͳҪڲıԭϵͳе»Щݹϵͳݡ
ͨʽݿ(ODBC)ǿʹñ׼SQLṩODBCضݿ⡣ȻͻΪֱͨODBCЩϵͳȡݵĲѯʽȻ¼ѵ㣺
(1)ϵͳݿݽṹͣڿͻ˰ûҪʵݲѯ
(2)ڲͬϵͳ˲ͬݿ⣬ڷʸʱƵͬݿ⽨ӡϵͳ˹ĹЧʡ
(3)Щϵͳõǲ֧ʵıݿ⣬޷Ϊݿʡ
Щ(رǵ޷˷)ǾͨODBCֱӷʵķʽȡ·ʽϵͳ
ͨʹݹܵĸϵͳݷֱݿȽ˵޷ͨʹODBCֱӷʵϵͳ⡣ͨݹƿԭݿĽṹȫûҪѡҪݣӦݿṹӶΪͻṩ˼ıͬʱûЩϵͳݵʱֻҪͬǵݿһӾͿԷϵͳиصݣֱͬͨODBCϵͳݿȴϵͳӶĹЧʡ
ͨһƵʵ̸̸˼ľʵ֡
人ܵú˾ϢϵͳУûҪ¡ϡ豸ȵϵͳϢǹ˾ѾԼĲ¡豸ϵͳвϵͳʹõϵͳʹõ²ͳһ涨¹ϵͳʹõһԼFOXPRO 2.5Ĺ豸ϵͳǹר豸豸ϵͳΪ档
ʹõǰ̨PB̨SQL SERVERݿĿƽ̨ڸϵͳṩһPBĿͻʹPBݹܵڿͻʵݿĹ롣
ڳʹPBṩݹܵʵݿ֮ת봫ʮַ㣬ȱ봴һ׼PBû׼ûǶPBݹܵϵͳļ̳С

ͼѡOKݹܵûĴѡûƣ洢ϺͿڳʹôû
ʹݹܵݵת봫֮ǰͨODBCֱΪԴıصݿԼΪĿĵݿӡ£
ȶȫֱ
transaction client_ trans, server_trans
ݹ봰ڵopen¼зֱԴݿ⡢Ŀݿӵĳ
client_trans=CREATE TRANSACTION
server_trans=CREATE TRANSACTION
//Դݿ
client_trans.DBMS=profilestring("pipeline.ini", "client", "DBMS","")
client_trans.Database=profilestring("pipeline.ini", "client", "Database","")
client_trans.LogID=profilestring("pipeline.ini", "client", "LogID", "")
client_trans.LogPass=profilestring("pipeline.ini", "client", "LogPass","")
client_trans.ServerName=profilestring("pipeline.ini", "client", "ServerName","")
client_trans.UserID=profilestring("pipeline.ini", "client", "UserID", "")
client_trans.DBPass=profilestring("pipeline.ini", "client", "DBPass", "")
client_trans.Lock=profilestring("pipeline.ini", "client", "Lock", "")
client_trans.DbParm=profilestring("pipeline.ini", "client", "DbParm", "")connect 
using client_trans; //Դݿ⽨
//Ŀݿ
server_trans.DBMS=profilestring("pipeline.ini", "server", "DBMS", "")
server_trans.Database=profilestring("pipeline.ini", "server", "Database","")
server_trans.LogID=profilestring("pipeline.ini", "server", "LogID", "")
server_trans.LogPass=profilestring("pipeline.ini", "server", "LogPass","")
server_trans.ServerName=profilestring("pipeline.ini", "server", "ServerName","")
server_trans.UserID=profilestring("pipeline.ini", "server", "UserID", "")
server_trans.DBPass=profilestring("pipeline.ini", "server", "DBPass","")
server_trans.Lock=profilestring("pipeline.ini", "server", "Lock","")
server_trans.DbParm=profilestring("pipeline.ini", "server", "DbParm","")
connect using client_trans; //Ŀݿ⽨
settransobject(dw_l, d_trans)
ԴĿݿODBCǿ32λODBCԴлãϵͳĿͻODBCûдԴ밲װӦݿODBC򣬲32λODBCԴнӦԴ
Ȼ󣬾ͿPBж彫ҪڳӦõݹܵһµݹֱܵԴݿ⡢ĿݿӡѡҪݱѡҪֶΣĿݿֶεͬ͡ʱѡʵĹ뷽ʽPBṩ˴¡ˢ¡׷ӡύֹ뷽ʽύļ¼һѡȫ(all)
󣬾ͿʹPBṩĺݹܵˡPBṩݹܵвĺstart( )repair( )cancel( )ֱȡݹܵĲ
ݹܵĳ£
int pipemsg
long stime, etime
my_pipeline cstrans //my_pipelineΪԶݹܵû
cstrans=create my_pipeline
cstrans.dataobject="client_server" 
//client_serverΪûݹܵ
stime=cpu( )//ȡݴִʱ
pipemsg=cstrans.start(server_trans, client_trans, dw_1)
//ݹܵ
etime=cpu( )
trans_time.text=string((etime_stime)/1000,"##0.0") + " secs"
ִݹܵʱʹrepair( )ͨȫserver_transĿݿ⣬repair( )ͨȡϢڵϢĿݿ⡣ʵ£
cstrans.repair(server_trans)
Ȼͨcancel( )ǿʱֹͣһִеݹܵУ
cstrans.cance1( )
ͨʹݹܵϵͳݿݹݿеĸPBͻֻҪSQL ServerݿͿѸٻò¡豸ϵȸϵͳݡͨ涨ڵݹ룬֤˷ݵЧԡʵ֤ͨݹܵҵйϵͳݵʮַЧġ
ʯ(ѧԿϵ 人 430074)
(ѧԿϵ 人 430074)
ο
l SQL Server 6.5ָ
2 ־ƽ, 쳣ʤ. 赺-PowerBuilderݿϿ
ոڣ1999726
