连接串

      语言类学习笔记 2006-2-6 18:18
const
sMdbStr = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source= %S ;Persist Security Info=False';

sVfpStr1 ='Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="Driver={Microsoft Visual FoxPro Driver};'
+'UID=;SourceDB=%S;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"';

sVfpStr='Provider=MSDASQL.1;Extended Properties="Driver={Microsoft Visual Foxpro Driver};SourceType=DBF;SourceDB=%S;"';

sSQL_NT ='Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=%S;Data Source=%S';

sSQL_CodeSn ='Provider=SQLOLEDB.1;Password=%S;Persist Security Info=True;User ID=%S;Initial Catalog=%S;Data Source=%S';

sODBCStr ='Provider=MSDASQL.1;Persist Security Info=False;Data Source=%S';



sVfpStr4= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source="%s";Extended Properties=dbase 5.0;'; (DBF)


Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=.;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

标签集:TAGS:
回复Comments() 点击Count()

回复Comments

{commentauthor}
{commentauthor}
{commenttime}
{commentnum}
{commentcontent}
作者:
{commentrecontent}