//读写文件
function TBkg_NewActFrm.ProcessCreateDBFile (const FileName:string):string;
var
szPath,szTmpFile1,szTmpFile2: string;
FTmp1,FTmp2:TextFile;
szTemp:string;
begin
szPath:=ExtractFilePath(Application.EXEName);
szTmpFile1:=szPath+FileName;
szTmpFile2:=szPath+'tmp.sql';
AssignFile(FTmp1,szTmpFile1);
AssignFile(FTmp2,szTmpFile2);
Reset(FTmp1);
ReWrite(FTmp2);
while not EOF(FTmp1) do
begin
Readln(FTmp1,szTemp);
if Pos('setuser',lowercase(szTemp))>0 then continue;
if Trim(szTemp)<>'' then szTemp:=ReplaceDataType(szTemp);
writeln(FTmp2,szTemp);
end;
CloseFile(FTmp1);
CloseFile(FTmp2);
Result:='tmp.sql';
end;
with TRegistry.Create do
begin
RootKey:=HKEY_LOCAL_MACHINE;
OpenKey('\Software\ODBC\ODBC.INI\ODBC Data Sources',False);
WriteString('aliasename','SQL Server');
OpenKey('\Software\ODBC\ODBC.INI\aliasename',True);
WriteString('Driver','C:\WINDOWS\SYSTEM\SQLSRV32.dll');
WriteString('LastUser','aliasename');
WriteString('Server','202.109.10.92');
free
end
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
写注册表吧:
with TRegistry.Create do
begin
RootKey := HKEY_CURRENT_USER;
if OpenKey('\Software\ODBC\ODBC.INI', False) then
begin
写入四个key Vaule(:string)
"Database",连接哪个数据库
"Driver"(比较麻烦找到系统目录中的sqlsrv32.dll)
"lastUser"(SQL 的用户名)
"Server"(SQL Server服务器名称)
end;
CloseKey;
Free;
end;