"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=" · AS/400
· OLE DB
o IBM Client Access OLE DB provider:
"PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME;Uid=myUserName;Pwd=myPwd"
Where MY_SYSTEM_NAME is the name given to the system connection in OperationsNavigator
· ODBC
o IBM Client Access ODBC driver:
"Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUserName;Pwd=myPwd"
· Exchange
· OLE DB
o Exchange OLE DB provider:
"ExOLEDB.DataSource"
Specify store in the connection open command like this: conn.open "http://servername/mypublicstore"Check out this article at msdn >> and this one at Addison-Wesley >>
· Visual FoxPro
· OLE DB, OleDbConnection (.NET)
o Database container (.DBC):
"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine" o Free table directory:
"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general" o Force the provider to use an ODBC DSN:
""Provider=vfpoledb.1;DSN=MyDSN""
Read more (Microsoft msdn) >>
· ODBC
o Database container (.DBC):
"Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO" o 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
· Pervasive
· ODBC
o Standard:
"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"
Pervasive ODBC info >>
· OLE DB
o Standard:
"Provider=PervasiveOLEDB;Data Source=C:\path"
Pervasive OLE DB info >>
· UDL
· UDL
o UDL:
"File Name=c:\myDataLink.udl;"
· OLE DB
o IBM Client Access OLE DB provider:
"PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME;Uid=myUserName;Pwd=myPwd"
Where MY_SYSTEM_NAME is the name given to the system connection in OperationsNavigator
· ODBC
o IBM Client Access ODBC driver:
"Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUserName;Pwd=myPwd"
· Exchange
· OLE DB
o Exchange OLE DB provider:
"ExOLEDB.DataSource"
Specify store in the connection open command like this: conn.open "http://servername/mypublicstore"Check out this article at msdn >> and this one at Addison-Wesley >>
· Visual FoxPro
· OLE DB, OleDbConnection (.NET)
o Database container (.DBC):
"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine" o Free table directory:
"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general" o Force the provider to use an ODBC DSN:
""Provider=vfpoledb.1;DSN=MyDSN""
Read more (Microsoft msdn) >>
· ODBC
o Database container (.DBC):
"Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO" o 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
· Pervasive
· ODBC
o Standard:
"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"
Pervasive ODBC info >>
· OLE DB
o Standard:
"Provider=PervasiveOLEDB;Data Source=C:\path"
Pervasive OLE DB info >>
· UDL
· UDL
o UDL:
"File Name=c:\myDataLink.udl;"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货