ado 用这个连接不行!
ADOConn.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Server.MapPath("***.mdb");Persist Security Info=False;Jet OLEDB:Database Password=12345';
碰到一个数据库要作打印的二次开发,现在没有办法连接数据库!
ADOConn.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Server.MapPath("***.mdb");Persist Security Info=False;Jet OLEDB:Database Password=12345';
碰到一个数据库要作打印的二次开发,现在没有办法连接数据库!
procedure TForm1.Button1Click(Sender: TObject);
var
connstr: string;
begin
try
ConnStr := 'Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=admin;Data Source=C:\Documents and Settings\zxf\桌面\新建 Microsoft Office Access 应用程序.mdb;Persist Security Info=True;Jet OLEDB:Database Password=123123';
ADOConnection1.Connected := false;
ADOConnection1.ConnectionString := Connstr;
ADOConnection1.LoginPrompt :=false;
ADOConnection1.connected:=True;
showmessage('ok');
except
showmessage('error');
end;
end;
直接ADOCONNECTION.CONNECTIONSTRING='FILENAME=./conn.udl';
方便修改与配置,数据库文件想放哪放哪,想用啥数据库就用啥数据库
//函数名称: GetConnectionString
//函数功能: 获得连接数据库字符串
//------------------------------------------------------------------------------function TDataModule1.GetConnectionString: string;
var iniSysconfig:TIniFile;
begin
try
iniSysconfig:=TIniFile.Create(ExtractFilePath(Application.ExeName)+'sysconfig.ini');
result:='Provider=SQLOLEDB;'+
'Data Source='+Trim(iniSysconfig.ReadString('DBConfig','Data Source',''))+';'+
'Initial Catalog=Community;'+
'User ID='+Trim(iniSysconfig.ReadString('DBConfig','User ID',''))+';'+
'Password='+Trim(iniSysconfig.ReadString('DBConfig','Password',''))+';'+
'Persist Security Info=True';
finally
iniSysconfig.Free;
end;
end;
if ADOConn.Connected then ADOConn.Close; ADOConn.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\permis.mdb;Persist Security Info=False;Jet OLEDB:Database Password=123456';
ADOConn.Open();