数据库连接字符串大全

• 
  
  •  Database container (.DBC):
    
    "Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine"
    
    
    
  •  Free table directory:
    
    "Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general"
    
    
    
  •  Force the provider to use an ODBC DSN:
    
    ""Provider=vfpoledb.1;DSN=MyDSN""

    Read more (Microsoft msdn) >>

•  ODBC
  
  
  •  Database container (.DBC):
    
    "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO"
    
    
    
  •  Free Table directory:
    
    "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO"

    "Collate=Machine" is the default setting, for other settings check the list of supported collating sequences >>

  
  Microsoft Visual Foxpro site: http://msdn.microsoft.com/vfoxpro
  
  

精品推荐

热点TOP10

特别推荐