网上找的代码,经过简单改造程序可以自动配置odbc,数据库无密码时可以连接,但数据库有密码时不知道如何提交密码,请各位朋友帮忙查看一下,如何把edit3里边的密码写到odbc的登录数据库密码里边,先谢了。procedure Tpara_F.Button1Click(Sender: TObject);
var
registerTemp: TRegistry;
bData : array[ 0..0 ] of byte;
ip,username,pass:string;
begin
ip:=edit1.Text;
username:=trim(edit2.Text);
pass:=trim(edit3.Text);
registerTemp:= TRegistry.Create;
with registerTemp do
begin
RootKey:=HKEY_LOCAL_MACHINE;
if OpenKey('Software\ODBC\ODBC.INI\ODBC Data Sources',True) then
begin
WriteString( 'MyAccess', 'SQL Server' );
end
else
begin
exit;
end;
CloseKey;
if OpenKey('Software\ODBC\ODBC.INI\MyAccess',True) then
begin
WriteString( 'Database', 'kq' );
WriteString( 'Driver', 'C:\WINNT\System32\SQLSRV32.dll' );
WriteString( 'LastUser', 'kq' );
WriteString( 'Server', ip );
WriteString( 'Trusted_Connection', 'No' );
bData[0] := 0;
WriteString('UserName',username);
WriteString('Password',pass);
WriteBinaryData( 'Exclusive', bData, 0 );
WriteBinaryData( 'ReadOnly', bData, 0 );
end
else
begin
exit;
end;
CloseKey;
Free;
end;
login_f.Show;end;
var
registerTemp: TRegistry;
bData : array[ 0..0 ] of byte;
ip,username,pass:string;
begin
ip:=edit1.Text;
username:=trim(edit2.Text);
pass:=trim(edit3.Text);
registerTemp:= TRegistry.Create;
with registerTemp do
begin
RootKey:=HKEY_LOCAL_MACHINE;
if OpenKey('Software\ODBC\ODBC.INI\ODBC Data Sources',True) then
begin
WriteString( 'MyAccess', 'SQL Server' );
end
else
begin
exit;
end;
CloseKey;
if OpenKey('Software\ODBC\ODBC.INI\MyAccess',True) then
begin
WriteString( 'Database', 'kq' );
WriteString( 'Driver', 'C:\WINNT\System32\SQLSRV32.dll' );
WriteString( 'LastUser', 'kq' );
WriteString( 'Server', ip );
WriteString( 'Trusted_Connection', 'No' );
bData[0] := 0;
WriteString('UserName',username);
WriteString('Password',pass);
WriteBinaryData( 'Exclusive', bData, 0 );
WriteBinaryData( 'ReadOnly', bData, 0 );
end
else
begin
exit;
end;
CloseKey;
Free;
end;
login_f.Show;end;
解决方案 »
- delphi迭代算法
- FastReport2.5如何不显示空值并格式化显示小数?
- 关于杀死进程
- 请问:如何实现邮件客户端对上次输入的账号信息的调用?
- 各位老大,我是菜鸟,请问一个关于在MEMO控件里面如何对某一行改变颜色的问题
- Operation must be performed on the cuttent session什么意思?
- 如何实现翻页???????????????????????????????
- 如何使maskedit获得焦点时,光标在最左面?
- 怎么触发动态创建的按钮的单击和双击事件?
- 如何用ADO控件打开有密码的Access数据库?
- 一个关于服务器的问题
- adoquery的问题
请问密码怎么设在DataBase的Params里呢?能讲的清楚一些吗?先谢了。