΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
2000Vol.19No.6P.15,40




VBSQL ServerԶ뷢Email
źԴֿ˱
ժ ҪͨVBSQL ServerļɣVBеԶݿԶݶؼݿжȡйصĲƷϢγEmailķ
ؼʣԶݿ Զݶ ODBC ʼ
ݿ⼼ĲϷչԼݲֿĳ֣๫˾ݴݿУݿϵͳ(磺SQL ServerOracleSybase)ݽЧĹɴҲݿ֮ͨ⡣һݿͨŵļ㷽VBؼSQL ServerʵԶ͵ʼĹܣӶʵ˰칫Զ
1  Emailܵʵ
ϵͳͨVBMAPI SessionMAPI Messageؼ亯EmailġMAPIȫΪʼӦóӿ(Mail Application Programmer Interface)Windowsϵͳһ֣MAPIŷϵͳͼ1ʾMAPIһϵеĺϵͳǿɽκڵʼӦóӦMAPIϢ޷磬ͨʹMAPIMicrosoft ExchangeϢϵͳɱӵ˽ûõʼϵͳͳһĽӿڣ·ѡMAPI DLL(16λ)MAPI32.DLL(32λ)û뿼Ǹַ֮ԷؿʼϵͳܱһʼϵͳҪõ4MAPIϢຯַຯຯպͽຯڱĿк

ͼ1  MAPIŷϵͳ
(1)Ϣຯеcompose(ձ༭壬Աдʼ)send(дõʼ)signon(¼ʼ磺Windows95ExchangeWindows NTWindows message)
(2)պͽຯеRecipdisplayName(ռ˵Emailַ)RecipType(ϢںηֵΪ0ʾΪߣ1ʾTo2ʾCopy)ͨͿԷEmailˡӦעǣVBMAPIؼҪ¼֧MAPI.DLLʼMicrosoft ExchangeWindows Messageing֧MAPI.DLLʼʱʾlogin failed
2  γEmailı
EmailҪһЩزƷϢЩϢֲݿĲͬУ˳ҪݿӣԲͬصıжȡϢγɷҪEmailıVB3ݿķ
(1)RDO  RDCݿӵĳ
(2)ODBC APIֱݿӡ
(3)VBSQL DBLibrary APIֱSQL Server

3ַݿʾͼͼ2ʾ

ͼ2  ݿķݿĲ
пʽݿ⻥(ODBC)Ӧóƽӿ(API)ݿ޹صıģͣṩĵһAPIӿڣԷκξODBCݿݿ迼ODBCݼʹODBC APIӦóбشģ͵ܺԡͬʱı̷൱ͨõģڶݿʽVisual Basic Library for SQL Server(VBSQL)ΪVisual BasicMicrosoft SQL ServerرơDBLibrary APIʵ֡VBSQLṩ˼еݿAPI֧ΪMicrosoft SQL ServerؽӿڡVBSQLODBC API֮ڣǶṩ㷺ԣĳЩ£ṩRDOõĶSQL ServerķʡȻRDO  RDCݿӵĳУRDO  RDCҲͨõײODBC APIݿͨţ˾һԡʹODBC APIVBSQL DBLibrary API޶ȵֱӿݿ⣬Եõߵܺ͸ԣȴӳĸԡϵͳں̨ÿֻ1ΣԳٶȺûкܸҪ󡣿ǵԺһԣRDORDCؼʵֶݿķʡͨԶݿ(RDC)ԿԴӵͬʱһԶݶ(RDO)Ľ(rdoResultset)ҪӵԴӦODBC AdministratorȽãӵݿAccessSQL ServerFoxproExcelȡRDCԴԺ󣬾ͿOpenResultset(Select *fromWhere)佨µRDOͿԷݱӶõõϢ
ͼ3һԶɵEmail

ͼ3  ԶɵEmail
3  SQL ServerȹʵֳԶ
SQL ServerһSQL Executive񣬸÷й¼;ĹܡܿԶԶõеȡһĲ£
(1)SQL Executive ManagerѡӦķ
(2)Server˵ϵScheduled TasksManage Scheduled Tasksڣ
(3)New Tasks
(4)ڳֵNAMEԻУ
(5)TypeѡCmdExecΪCOMEXEļ
(6)ѡEnableѡʹôԱȣ
(7)CommandĿִļ·
(8)ظִѡRecurring
(9)OccursµDailyÿִ1Σ
(10)OK
(11)Add
Ķ壬񽫸Ҫÿִ1ΡӦע⣬Ҫȱ뱣֤SQL Executive ManagerѾ
ʹVBSQL ServerʼܲһЩĹҪ󡣱ĽַVBʵַʼݿͨŵĹܣͬʱSQL ServerȹܣʵEmailĹɺԶʱ͡
źԴҵѧϢźŴо100022
ֿ˱󣨱ҵѧϢźŴо100022
ոڣ19991212
