各种数据库链接字符串
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
delphi应用
AContext.Connection.IOHandler.WriteLn('');
IdTCPServer1Execute里面
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\CodeSource\delphi\qdms_zp\MP\Client\bin\hhl.mdb;Persist Security Info=False;
列出连结串属性Extended properties,
DBase 5.0
DBASE IV
FoxPro 3.0
Paradox 7.X
Excel 8.0
text;HDR=YES;FMT=Delimited
-------------------------------------
* *.DB
1. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\CodeSource\delphi\qdms_zp\MP\MixWare\DATA\Daily;Extended Properties=Paradox 7.x;Persist Security Info=True;Mode=Share Deny None;Jet OLEDB:Database Password=test;
2. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\CodeSource\delphi\qdms_zp\MP\MixWare\DATA\Daily;Extended Properties=paradox 7.x;Persist Security Info=False;Mode=Share Deny None;//";Jet OLEDB:Engine Type=82
3. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\CodeSource\delphi\qdms_zp\MP\MixWare\DATA\Daily\;Mode=Share Deny None;Jet OLEDB:Engine Type=82;
4. Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\CodeSource\delphi\qdms_zp\MP\MixWare\DATA\Daily\;Mode=Share Deny None;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=82;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;
--------------------------------------------
* *.mdb
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\CodeSource\delphi\qdms_zp\MP\Client\bin\hhl.mdb;Persist Security Info=False;
-------------------------------------------
* *.DBF
1. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp;Extended Properties="dBase 5.0;";Persist Security Info=False
2. Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:\Delphi;Mode=Share Deny None;Extended Properties=dBase 5.0;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=18;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
------------------------------------------
* *.XLS
Jet OLEDB:Engine Type=34
Excel联接ADO串
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:\test\change.xls;Extended Properties=Excel 5.0;Persist Security Info=False
---------------------------------------------
* 连接oracle10g数据库的ConnectionString为：
'Provider=OraOLEDB.Oracle.1;Password=teacher;Persist Security Info=True;User ID=
teacher;Data Source=demo'
其中demo为net中配置的服务名。