求教: ADO 连接字符串。 ACCESS带密码的。 譬如 user:admin ,pwd:123.请详细点。本人菜鸟!谢谢。
解决方案 »
- 如何知道TIdTcpServer与TidTcpClient断开连接?
- 怎样生成网页?
- 请看图中的浮动按钮是怎么做的
- 如何用DbExpress连接oracle8.1.7
- 求SQL语句,也许很难也,许很简单。与除零有关!!!
- 删贴的斑竹,给我进来!!!!!!!!!!!!!!!!!!!!!!!!!……
- 党政内网进入后台开外网端口
- 请问怎么动态创建鼠标指针?(我出100分,要真正的动态创建)
- 如何定制鼠标右键(给出注册表修改例程即可,无需DELPHI源码,因为我看不懂)
- 如何抓取远程计算机的屏幕
- 求高手(不高也行)QReport预览时如何默认为Zoom100.我弄了一个晚上了帮看看下面的代码吧!
- 有关自动填表的问题,如果网页中是Checkbox,和Select如何让checkbox取消选择,Select选择第二项?
Password=密码;
User ID=用户名;
Data Source=Test.mdb;
Persist Security Info=True
请给分!
+ExtractFilePath(application.ExeName)+'database\Student.mdb;Persist Security Info=False;Jet OLEDB:DataBase PassWord=123';
Standard security:"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;" Workgroup (system database):"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;" With password:"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"
Standard Security:"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" Trusted Connection:"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Prompt for username and password:oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=Aron1;Initial Catalog=pubs;" Connect via an IP address:"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
var
dbfile: string;
begin
dbfile:= ExtractFilePath(application.ExeName)+'account.mdb';
try
dmdb.adoconn.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbfile;Persist Security Info=False;Jet OLEDB:Database Password=qq12457';
dmdb.adoConn.Connected:= True;
finally
//
end;
end;
编译通过,但是程序执行起来就提示错误。
告诉我email我发给你。
var
Source: string;
begin
with ADOConnection1 do
begin
Close;
Source := ExtractFilePath(Application.ExeName);
ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='
+ Source + '\work.mdb;Persist Security Info=False;Jet OLEDB:Database Password=该数据库密码';
Open;
end;
end;