function TSeaFun.GetConnErrs(Conn: TADOConnection): string;
var
i:integer;
begin
result:='';
if not Assigned(Conn) then
exit;
if Conn.Errors.Count>0 then
begin
for i:=0 to Conn.Errors.Count-1 do
if result='' then
result:=Conn.Errors.Item[i].Description
else
result:=result+#13#10+Conn.Errors.Item[i].Description;
end;
end;
5. 利用 ODBC 连接 DBF
function TSeaFun.ConnDBF_odbc(Conn: TADOConnection; FileName: string;
var sErr: string; ConnMode: integer): boolean;
var
str:string;
begin
//判断连接控件是否存在
if not Assigned(Conn) then
begin
result:=false;
sErr:='所需 TADOConnection 控件不存在';
exit;
end;
6.利用 VFPOLEDB 连接 DBF 或 DBC
function TSeaFun.ConnVFP(Conn: TADOConnection; PathSource: string;
var sErr: string; ConnMode:integer): boolean;
var
str:string;
begin
//判断连接控件是否存在
if not Assigned(Conn) then
begin
result:=false;
sErr:='所需 TADOConnection 控件不存在';
exit;
end;
7. 连接 Excell 文件(Excel 也可以看作成数据库的)
function TSeaFun.ConnXLS(Conn: TADOConnection; FileName: string;
var sErr: string): boolean;
var
str:string;
begin
//判断连接控件是否存在
if not Assigned(Conn) then
begin
result:=false;
sErr:='所需 TADOConnection 控件不存在';
exit;
end;
//判断文件是否存在
if not FileExists(FileName) then
begin
result:=false;
sErr:='文件 '+FileName+' 不存在';
exit;
end;
function ConnMss(Conn: TADOConnection; ServerName, DBName, Logid,
PassWord: string; var sErr: string): boolean;
var
str:string;
begin
//判断连接控件是否存在
if not Assigned(Conn) then
begin
result:=false;
sErr:='所需 TADOConnection 控件不存在';
exit;
end;
2. MDB
function TSeaFun.ConnMDB(Conn: TADOConnection; FileName: string;
var sErr: string; UserID,Password:string; ConnMode:integer): boolean;
var
str:string;
begin
//判断连接控件是否存在
if not Assigned(Conn) then
begin
result:=false;
sErr:='所需 TADOConnection 控件不存在';
exit;
end;
3. dBase.DBF
function TSeaFun.ConnDBF(Conn: TADOConnection; FileName: string;
var sErr: string; ConnMode:integer): boolean;
var
str:string;
begin
//判断连接控件是否存在
if not Assigned(Conn) then
begin
result:=false;
sErr:='所需 TADOConnection 控件不存在';
exit;
end;
4. DSN 的方式连接 DBF
function TSeaFun.ConnDBF_dsn(Conn: TADOConnection; DsnName: string;
var sErr: string; ConnMode: integer): boolean;
var
str:string;
begin
//判断连接控件是否存在
if not Assigned(Conn) then
begin
result:=false;
sErr:='所需 TADOConnection 控件不存在';
exit;
end;