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中配置的服务名。