.NET中各种数据库连接大全(32)

王朝c#·作者佚名 2007-05-11

宽屏版字体: 小|中|大|超大

Pervasive

ODBC

Standard:

"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"

Standard:

"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"

UDL

UDL:

"File Name=c:\myDataLink.udl;"

UDL:

"File Name=c:\myDataLink.udl;"

Excel

ODBC

Standard:

"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"

OLE DB

Standard:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=Excel 8.0;HDR=Yes;" "HDR=Yes;" indicates that the first row contains columnnames, not data

OLE DB

Standard:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=Excel 8.0;HDR=Yes;" "HDR=Yes;" indicates that the first row contains columnnames, not data

Standard:

"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"

Standard:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=Excel 8.0;HDR=Yes;" "HDR=Yes;" indicates that the first row contains columnnames, not data

DBF / FoxPro

ODBC

standard:

"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"

OLEDB, OleDbConnection (.NET)

standard:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password="

OLEDB, OleDbConnection (.NET)

standard:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password="

standard:

"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"

standard:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password="

Pervasive

ODBC

Standard:

"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"

Standard:

"Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"

UDL

UDL:

"File Name=c:\myDataLink.udl;"

UDL:

"File Name=c:\myDataLink.udl;"

DBF / FoxPro

ODBC

standard:

"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"