`

asp.net数据库链接字符串详解

 
阅读更多
名称 ADO.NET连接字符串

说明 ADO.NET连接字符串:SQL Server,SQL Server 2005,ACCESS,Oracle,MySQL,Interbase,IBM DB2,Sybase,Informix,Ingres,Mimer SQL,Lightbase,PostgreSQL,Paradox,DNS,Firebird,Excel ,Text,DBF / FoxPro,AS/400 (iSeries),Exchange,Visual FoxPro,Pervasive,UDL。
1 - SQL Server
2 - SQL Server 2005
3 - ACCESS, Oracle
4 - MySQL, Interbase, IBM DB2
5 - Sybase, Informix, Ingres, Mimer SQL, Lightbase, PostgreSQL, Paradox, DNS
6 - Firebird, Excel , Text, DBF / FoxPro, AS/400 (iSeries), Exchange, Visual FoxPro, Pervasive, UDL
1 SQL Server
ODBC
标准安全 " Driver={SQL Server}; Server=Aron1; Database=pubs; Uid=sa; Pwd=asdasd; "
//******************
当连接远程服务器时,需指定地址、端口号和网络库
      "Driver={SQL Server};Server=130.120.110.001;Address=130.120.110.001,1052;Network=dbmssocn;
      Database=pubs;Uid=sa;Pwd=asdasd;"
      注:Address参数必须为IP地址,而且必须包括端口号

信任的连接 " Driver={SQL Server}; Server=Aron1; Database=pubs; Trusted_Connection=yes; "
提示输入用户名和密码 oConn.Properties(" Prompt" ) = adPromptAlways
oConn.Open " Driver={SQL Server}; Server=Aron1; DataBase=pubs; "
OLE DB, OleDbConnection (.NET)
标准安全 " Provider=sqloledb; Data Source=Aron1; Initial Catalog=pubs; User Id=sa; Password=asdasd; "
信任的连接 " Provider=sqloledb; Data Source=Aron1; Initial Catalog=pubs; Integrated Security=SSPI; "
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
提示输入用户名和密码 oConn.Provider = " sqloledb"
oConn.Properties(" Prompt" ) = adPromptAlways
oConn.Open " Data Source=Aron1; Initial Catalog=pubs; "
IP地址连接管道 " Provider=sqloledb; Data Source=190.190.200.100,1433; Network Library=DBMSSOCN; Initial Catalog=pubs; User ID=sa; Password=asdasd; "
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
SqlConnection (.NET)
标准安全 " Data Source=Aron1; Initial Catalog=pubs; User Id=sa; Password=asdasd; "
- or -
" Server=Aron1; Database=pubs; User ID=sa; Password=asdasd; Trusted_Connection=False"
(both connection strings produces the same result)
信任的连接 " Data Source=Aron1; Initial Catalog=pubs; Integrated Security=SSPI; "
- or -
" Server=Aron1; Database=pubs; Trusted_Connection=True; "
(both connection strings produces the same result)
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
IP地址连接管道 " Data Source=190.190.200.100,1433; Network Library=DBMSSOCN; Initial Catalog=pubs; User ID=sa; Password=asdasd; "
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
定义SqlConnection对象 C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString=" my connection string" ;
oSQLConn.Open();
VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString=" my connection string"
oSQLConn.Open()
Data Shape
MS Data Shape " Provider=MSDataShape; Data Provider=SQLOLEDB; Data Source=Aron1; Initial Catalog=pubs; User ID=sa; Password=asdasd; "

2 SQL Server 2005
SQL Native Client ODBC Driver
标准安全 " Driver={SQL Native Client}; Server=Aron1; Database=pubs; UID=sa; PWD=asdasd; "
信任的连接 " Driver={SQL Native Client}; Server=Aron1; Database=pubs; Trusted_Connection=yes; "
Equivalents
Integrated Security=SSPI equals Trusted_Connection=yes
提示输入用户名和密码 oConn.Properties(" Prompt" ) = adPromptAlways
oConn.Open " Driver={SQL Native Client}; Server=Aron1; DataBase=pubs; "
授权的MARS(多重活动结果集) " Driver={SQL Native Client}; Server=Aron1; Database=pubs; Trusted_Connection=yes; MARS_Connection=yes"
Equivalents
MultipleActiveResultSets=true equals MARS_Connection=yes
加密数据网络传输 " Driver={SQL Native Client}; Server=Aron1; Database=pubs; Trusted_Connection=yes; Encrypt=yes"
在本地SQL服务器实例附加数据库文件 " Driver={SQL Native Client}; Server=.\SQLExpress; AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname; Trusted_Connection=Yes; "
- or -
" Driver={SQL Native Client}; Server=.\SQLExpress; AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname; Trusted_Connection=Yes; "
(use |DataDirectory| when your database file resides in the data directory)
SQL Native Client OLE DB Provider
标准安全 " Provider=SQLNCLI; Server=Aron1; Database=pubs; UID=sa; PWD=asdasd; "
信任的连接 " Provider=SQLNCLI; Server=Aron1; Database=pubs; Trusted_Connection=yes; "
Equivalents
Integrated Security=SSPI equals Trusted_Connection=yes
提示输入用户名和密码 oConn.Properties(" Prompt" ) = adPromptAlways
oConn.Open " Provider=SQLNCLI; Server=Aron1; DataBase=pubs; "
授权的MARS(多重活动结果集) " Provider=SQLNCLI; Server=Aron1; Database=pubs; Trusted_Connection=yes; MarsConn=yes"
Equivalents
MarsConn=yes equals MultipleActiveResultSets=true equals MARS_Connection=yes
加密数据网络传输 " Provider=SQLNCLI; Server=Aron1; Database=pubs; Trusted_Connection=yes; Encrypt=yes"
在本地SQL服务器实例附加数据库文件 " Provider=SQLNCLI; Server=.\SQLExpress; AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname; Trusted_Connection=Yes; "
- or -
" Provider=SQLNCLI; Server=.\SQLExpress; AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname; Trusted_Connection=Yes; "
(use |DataDirectory| when your database file resides in the data directory)
SqlConnection (.NET)
标准安全 " Data Source=Aron1; Initial Catalog=pubs; User Id=sa; Password=asdasd; "
- or -
" Server=Aron1; Database=pubs; User ID=sa; Password=asdasd; Trusted_Connection=False"
(both connection strings produces the same result)
信任的连接 " Data Source=Aron1; Initial Catalog=pubs; Integrated Security=SSPI; "
- or -
" Server=Aron1; Database=pubs; Trusted_Connection=True; "
(both connection strings produces the same result)
IP地址连接管道 " Data Source=190.190.200.100,1433; Network Library=DBMSSOCN; Initial Catalog=pubs; User ID=sa; Password=asdasd; "
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
授权的MARS(多重活动结果集) " Server=Aron1; Database=pubs; Trusted_Connection=True; MultipleActiveResultSets=true"
Note! Use ADO.NET 2.0 for MARS functionality. MARS is not supported in ADO.NET 1.0 nor ADO.NET 1.1
在本地SQL服务器实例附加数据库文件 " Server=.\SQLExpress; AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname; Database=dbname; Trusted_Connection=Yes; "
- or -
" Server=.\SQLExpress; AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname; Trusted_Connection=Yes; "
Using " User Instance" on a local SQL Server Express instance " Data Source=.\SQLExpress; integrated security=true; attachdbfilename=|DataDirectory|\mydb.mdf; user instance=true; "
The " User Instance" functionality creates a new SQL Server instance on the fly during connect. This works only on a local SQL Server 2005 instance and only when connecting using windows authentication over local named pipes. The purpose is to be able to create a full rights SQL Server instance to a user with limited administrative rights on the computer. To enable the functionality: sp_configure 'user instances enabled','1' (0 to disable)
Using SQL Server 2005 Express? Don't miss the server name syntax: SERVERNAME\SQLEXPRESS (Substitute " SERVERNAME" with the name of the computer)
Context Connection - connecting to " self" from within your CLR stored prodedure/function
Context Connection - connecting to " self" from within your CLR stored prodedure/function
C# using(SqlConnection connection = new SqlConnection("context connection=true"))
{
connection.Open();
// Use the connection
}
Visual Basic Using connection as new SqlConnection("context connection=true")
connection.Open()
' Use the connection
End Using
Read more
When to use SQL Native Client? .Net applications
Do not use the SQL Native Client. Use the .NET Framework Data Provider for SQL Server (SqlConnection).
COM applications, all other then .Net applications
COM applications, all other then .Net applications
Use the SQL Native Client if you are accessing an SQL Server 2005 and need the new features of SQL Server 2005 such as MARS, encryption, XML data type etc. Continue use your current provider (OLE DB / ODBC through the MDAC package) if you are not connecting to an SQL Server 2005 (that's quite obvious eh..) or if you are connecting to an SQL Server 2005 but are not using any of the new SQL Server 2005 features.

3 ACCESS
ODBC
标准安全 "Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\mydatabase.mdb; Uid=Admin; Pwd=; "
工作组 "Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\mydatabase.mdb; SystemDB=C:\mydatabase.mdw; "
独占 "Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\mydatabase.mdb; Exclusive=1; Uid=admin; Pwd="
OLE DB, OleDbConnection (.NET)
标准安全 "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\somepath\mydb.mdb; User Id=admin; Password=; "
工作组 (system database) "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\somepath\mydb.mdb; Jet OLEDB:System Database=system.mdw; "
使用密码 "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\somepath\mydb.mdb; Jet OLEDB:Database Password=MyDbPassword; "
 
Oracle
ODBC
新版本 "Driver={Microsoft ODBC for Oracle}; Server=OracleServer.world; Uid=Username; Pwd=asdasd; "
旧版本 "Driver={Microsoft ODBC Driver for Oracle}; ConnectString=OracleServer.world; Uid=myUsername; Pwd=myPassword; "
OLE DB, OleDbConnection (.NET)
标准安全 "Provider=msdaora; Data Source=MyOracleDB; User Id=UserName; Password=asdasd; "
This one's from Microsoft, the following are from Oracle
标准安全 "Provider=OraOLEDB.Oracle; Data Source=MyOracleDB; User Id=Username; Password=asdasd; "
信任的连接 "Provider=OraOLEDB.Oracle; Data Source=MyOracleDB; OSAuthent=1; "
OracleConnection (.NET)
标准 "Data Source=MyOracleDB; Integrated Security=yes; "
This one works only with Oracle 8i release 3 or later
指定用户名和密码 "Data Source=MyOracleDB; User Id=username; Password=passwd; Integrated Security=no; "
This one works only with Oracle 8i release 3 or later
定义OracleConnection对象 C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connection string";
oOracleConn.Open();
VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connection string"
oOracleConn.Open()
Core Labs OraDirect (.NET)
标准 "User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"
Data Shape
微软数据模型 "Provider=MSDataShape.1; Persist Security Info=False; Data Provider=MSDAORA; Data Source=orac; user id=username; password=mypw"

4 MySQL
MyODBC
MyODBC 2.50 本地数据库 "Driver={mySQL}; Server=localhost; Option=16834; Database=mydatabase; "
MyODBC 2.50 远程数据库: "Driver={mySQL}; Server=data.domain.com; Port=3306; Option=131072; Stmt=; Database=my-database; Uid=username; Pwd=password; "
MyODBC 3.51 本地数据库 "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword; OPTION=3; "
MyODBC 3.51 远程数据库 "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=data.domain.com; PORT=3306; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword; OPTION=3; "
OLE DB, OleDbConnection (.NET)
标准 "Provider=MySQLProv; Data Source=mydb; User Id=UserName; Password=asdasd; "
Connector/Net 1.0 (.NET)
标准 "Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; "
Download the driver at MySQL Developer Zone
指定端口 "Server=Server; Port=1234; Database=Test; Uid=UserName; Pwd=asdasd; "
Default port is 3306. Enter value -1 to use a named pipe connection.
定义mysqlclient 连接对象 C#:
using MySql.Data.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; ";
oMySqlConn.Open();
VB.NET:
Imports MySql.Data.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "Server=Server; Database=Test; Uid=UserName; Pwd=asdasd; "
oMySqlConn.Open()
MySqlConnection (.NET)
eInfoDesigns.dbProvider "Data Source=server; Database=mydb; User ID=username; Password=pwd; Command Logging=false"
This one is used with eInfoDesigns dbProvider, an add-on to .NET
定义MySqlConnection连接对象 C#:
using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connection string";
oMySqlConn.Open();
VB.NET:
Imports eInfoDesigns.dbProvider.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connection string"
oMySqlConn.Open()
SevenObjects MySqlClient (.NET)
标准 "Host=server; UserName=myusername; Password=mypassword; Database=mydb; "
This is a freeware ADO.Net data provider from SevenObjects
Core Labs MySQLDirect (.NET)
标准 "User ID=root; Password=pwd; Host=localhost; Port=3306; Database=test; Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"
 
Interbase
ODBC, Easysoft
本地计算机 "Driver={Easysoft IB6 ODBC}; Server=localhost; Database=localhost:C:\mydatabase.gdb; Uid=username; Pwd=password"
远程计算机 "Driver={Easysoft IB6 ODBC}; Server=ComputerName; Database=ComputerName:C:\mydatabase.gdb; Uid=username; Pwd=password"
ODBC, Intersolv
本地计算机 "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)}; Server=localhost; Database=localhost:C:\mydatabase.gdb; Uid=username; Pwd=password"
远程计算机 "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)}; Server=ComputerName; Database=ComputerName:C:\mydatabase.gdb; Uid=username; Pwd=password"
OLE DB, SIBPROvider
标准 "provider=sibprovider; location=localhost:; data source=c:\databases\gdbs\mygdb.gdb; user id=SYSDBA; password=masterkey"
指定字符集 "provider=sibprovider; location=localhost:; data source=c:\databases\gdbs\mygdb.gdb; user id=SYSDBA; password=masterkey; character set=ISO8859_1"
指定规则 "provider=sibprovider; location=localhost:; data source=c:\databases\gdbs\mygdb.gdb; user id=SYSDBA; password=masterkey; role=DIGITADORES"
 
IBM DB2
OLE DB, OleDbConnection (.NET) from ms
TCP/IP "Provider=DB2OLEDB; Network Transport Library=TCPIP; Network Address=XXX.XXX.XXX.XXX; Initial Catalog=MyCtlg; Package Collection=MyPkgCol; Default Schema=Schema; User ID=MyUser; Password=MyPW"
APPC "Provider=DB2OLEDB; APPC Local LU Alias=MyAlias; APPC Remote LU Alias=MyRemote; Initial Catalog=MyCtlg; Package Collection=MyPkgCol; Default Schema=Schema; User ID=MyUser; Password=MyPW"
IBM's OLE DB Provider (shipped with IBM DB2 UDB v7 or above)
TCP/IP "Provider=IBMDADB2; Database=sample; HOSTNAME=db2host; PROTOCOL=TCPIP; PORT=50000; uid=myUserName; pwd=myPwd;"
ODBC
标准 "driver={IBM DB2 ODBC DRIVER}; Database=myDbName; hostname=myServerName; port=myPortNum; protocol=TCPIP; uid=myUserName; pwd=myPwd"

5 Sybase
ODBC
标准 Sybase System 12 (or 12.5) Enterprise Open Client "Driver={SYBASE ASE ODBC Driver}; Srvr=Aron1; Uid=username; Pwd=password"
标准 Sybase System 11 "Driver={SYBASE SYSTEM 11}; Srvr=Aron1; Uid=username; Pwd=password; Database=mydb"
Intersolv 3.10 "Driver={INTERSOLV 3.10 32-BIT Sybase}; Srvr=Aron1; Uid=username; Pwd=password;"
Sybase SQL Anywhere (former Watcom SQL ODBC driver) "ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbfolder\; Dbf=c:\mydatabase.db; Uid=username; Pwd=password; Dsn="""""
OLE DB
Adaptive Server Anywhere (ASA) "Provider=ASAProv; Data source=myASA"
Adaptive Server Enterprise (ASE) with Data Source .IDS file "Provider=Sybase ASE OLE DB Provider; Data source=myASE"
Adaptive Server Enterprise (ASE) "Provider=Sybase.ASEOLEDBProvider; Srvr=myASEserver,5000; Catalog=myDBname; User Id=username; Password=password"
- some reports on problem using the above one, try the following as an alternative -
"Provider=Sybase.ASEOLEDBProvider; Server Name=myASEserver,5000; Initial Catalog=myDBname; User Id=username; Password=password"
This one works only from Open Client 12.5 where the server port number feature works,following fully qualified connection strings to be used without definingfony .IDS Data Source files.

AseConnection (.NET)
标准 "Data Source='myASEserver'; Port=5000; Database='myDBname'; UID='username'; PWD='password'; "
定义AseConnection连接对象 C#:
using Sybase.Data.AseClient;
AseConnection oCon = new AseConnection();
oCon.ConnectionString="my connection string";
oCon.Open();
VB.NET:
Imports System.Data.AseClient
Dim oCon As AseConnection = New AseConnection()
oCon.ConnectionString="my connection string"
oCon.Open()
 
Informix
ODBC
Informix 3.30 "Dsn=''; Driver={INFORMIX 3.30 32 BIT}; Host=hostname; Server=myserver; Service=service-name; Protocol=olsoctcp; Database=mydb; UID=username; PWD=myPwd"
Informix-CLI 2.5 "Driver={Informix-CLI 2.5 (32 Bit)}; Server=myserver; Database=mydb; Uid=username; Pwd=myPwd"
OLE DB
IBM Informix OLE DB Provider "Provider=Ifxoledbc.2; password=myPw; User ID=myUser; Data ; Persist Security Info=true"
 
Ingres
ODBC
DSN-less "Provider=MSDASQL.1; DRIVER=Ingres; SRVR=xxxxx; DB=xxxxx; Persist Security Info=False; uid=xxxx; pwd=xxxxx; SELECTLOOPS=N; Extended Properties="""SERVER=xxxxx; DATABASE=xxxxx; SERVERTYPE=INGRES""
 
Mimer SQL
ODBC
标准安全 "Driver={MIMER}; Database=mydb; Uid=myuser; Pwd=mypw; "
提示输入用户名和密码 "Driver={MIMER}; Database=mydb;"
 
Lightbase
标准
标准 "user=USERLOGIN; password=PASSWORD; UDB=USERBASE; server=SERVERNAME"
 
PostgreSQL
Core Labs PostgreSQLDirect (.NET)
标准 "User ID=root; Password=pwd; Host=localhost; Port=5432; Database=testdb; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"
PostgreSQL driver
标准 "DRIVER={PostgreSQL}; SERVER=ipaddress; port=5432; DATABASE=dbname; UID=username; PWD=password; "
Npgsql by pgFoundry (.NET)
SSL activated "Server=127.0.0.1; Port=5432; Userid=myuserid; password=mypw; Protocol=3; SSL=true; Pooling=true; MinPoolSize=3; MaxPoolSize=20; Encoding=UNICODE; Timeout=20; SslMode=Require"
Without SSL "Server=127.0.0.1; Port=5432; Userid=myuserid; password=mypw; Protocol=3; SSL=false; Pooling=true; MinPoolSize=1; MaxPoolSize=20; Encoding=UNICODE; Timeout=15; SslMode=Disable"
 
Paradox
ODBC
5.X "Driver={Microsoft Paradox Driver (*.db )}; DriverID=538; Fil=Paradox 5.X; DefaultDir=c:\pathToDb\; Dbq=c:\pathToDb\; CollatingSequence=ASCII"
7.X "Provider=MSDASQL.1; Persist Security Info=False; Mode=Read; Extended Properties='DSN=Paradox; DBQ=C:\myDb; DefaultDir=C:\myDb; DriverId=538; FIL=Paradox 7.X; MaxBufferSize=2048; PageTimeout=600; '; Initial Catalog=C:\myDb"
OleDbConnection (.NET)
标准 "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\myDb; Extended Properties=Paradox 5.x;"
 
DNS
ODBC
DSN "DSN=myDsn; Uid=username; Pwd=; "
File DSN "FILEDSN=c:\myData.dsn; Uid=username; Pwd=;"

6 Firebird
ODBC - IBPhoenix Open Source
标准 "DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=masterkey; DBNAME=D:\FIREBIRD\examples\TEST.FDB"
.NET - Firebird .Net Data Provider
标准 "User=SYSDBA; Password=masterkey; Database=SampleDatabase.fdb; DataSource=localhost; Port=3050; Dialect=3; Charset=NONE; Role=; Connection lifetime=15; Pooling=true; MinPoolSize=0; MaxPoolSize=50; Packet Size=8192; ServerType=0"
 
Excel
ODBC
标准 "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=C:\MyExcel.xls; DefaultDir=c:\mypath; "
OLE DB
标准 "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\MyExcel.xls; Extended Properties=""Excel 8.0; HDR=Yes; IMEX=1"""
"HDR=Yes; " indicates that the first row contains columnnames, not data
"IMEX=1; " tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
 
Text
ODBC
标准 "Driver={Microsoft Text Driver (*.txt; *.csv)}; Dbq=c:\txtFilesFolder\; Extensions=asc,csv,tab,txt; "
OLE DB
标准 "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\txtFilesFolder\; Extended Properties=""text; HDR=Yes; FMT=Delimited"""
"HDR=Yes; " indicates that the first row contains columnnames, not data
 
DBF / FoxPro
ODBC
标准 "Driver={Microsoft dBASE Driver (*.dbf)}; DriverID=277; Dbq=c:\mydbpath; "
OLE DB, OleDbConnection (.NET)
标准 "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\folder; Extended Properties=dBASE IV; User ID=Admin; Password="
 
AS/400 (iSeries)
OLE DB, OleDbConnection (.NET)
IBM Client Access OLE DB provider "PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME; USER ID=myUserName; PASSWORD=myPwd"
IBM Client Access OLE DB provider "PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME; USER ID=myUserName; PASSWORD=myPwd; DEFAULT COLLECTION=MY_LIBRARY; "
ODBC
IBM Client Access ODBC driver "Driver={Client Access ODBC Driver (32-bit)}; System=my_system_name; Uid=myUserName; Pwd=myPwd"
 
Exchange
OLE DB
Exchange OLE DB provider "ExOLEDB.DataSource"
Specify store in the connection open command like this: conn.open "http://servername/mypublicstore"
 
Visual FoxPro
OLE DB, OleDbConnection (.NET)
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"
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"
 
Pervasive
ODBC
标准: "Driver={Pervasive ODBC Client Interface}; ServerName=srvname; "
OLD DB
标准: "Provider=PervasiveOLEDB; Data Source=C:\path"
 
UDL
UDL
UDL "File Name=c:\myDataLink.udl;"
分享到:
评论

相关推荐

    ASP.NET Oracle连接字符串

    ### ASP.NET Oracle连接字符串详解 在开发基于ASP.NET的应用程序时,经常需要与Oracle数据库进行交互。为了确保数据能够正确地被读取、写入,一个正确的连接字符串至关重要。本文将详细探讨如何设置一个适用于ASP...

    ASP.NET数据库入门经典--C#编程篇1.rar

    1. 连接数据库:创建SqlConnection对象,设置正确的连接字符串。 2. 执行SQL语句:创建SqlCommand对象,设置SQL命令,然后调用ExecuteReader、ExecuteNonQuery或ExecuteScalar方法。 3. 处理结果:如果执行的是查询...

    ASP.NET数据库操作大全

    ### ASP.NET数据库操作详解 #### 一、ASP.NET与数据库连接基础 在ASP.NET中进行数据库操作,首先需要建立与数据库的连接。这通常通过在Web.config文件中配置`<connectionStrings>`节点来实现,该节点包含一个或多...

    asp.net中如何使用ado.net连接数据库

    ### 连接字符串详解 连接字符串是ADO.NET中一个非常关键的部分,它决定了如何与数据库建立连接。连接字符串通常包含以下几个元素: - **Server**:指定SQL Server实例的名称或网络路径。 - **Database**:指定要...

    asp.net数据库备份及还原方法

    ### ASP.NET 数据库备份及还原方法详解 #### 一、引言 在软件开发与维护过程中,数据库备份与还原是一项非常重要的工作。它能够确保数据的安全性,避免因意外情况导致的数据丢失。对于使用ASP.NET进行开发的应用...

    .net数据库编程详解

    《.NET数据库编程详解》章节概述 在深入探讨.NET数据库编程的世界时,了解如何有效地连接和操作数据库至关重要。本章将详细阐述如何在ASP.NET环境中使用ADO.NET进行Web数据库应用设计,尤其对初学者而言,这是一份...

    asp.net 数据库操作

    ### ASP.NET 数据库操作知识点详解 #### 一、ASP.NET 数据库操作概述 在ASP.NET应用程序中进行数据库操作是一项常见的任务。它涉及到与数据库的连接、执行SQL命令(如查询、插入、删除等)、处理结果集等多个方面...

    asp.net数据库操作

    ### ASP.NET 数据库操作知识点详解 #### 一、ASP.NET 数据库操作概述 在ASP.NET开发中,数据库操作是一项非常重要的技术。通过数据库操作,我们可以实现数据的存储、查询、更新等功能,为用户提供动态的数据展示和...

    Asp.net数据库的相关知识

    **Asp.net数据库相关知识详解** 在Web开发领域,Asp.net是一个强大的平台,它提供了丰富的功能和工具来创建交互式、数据驱动的网站。在Asp.net中,数据库是核心部分,用于存储和管理应用程序的数据。本篇将深入探讨...

    ASP.NET连接SQL数据库实例

    ### ASP.NET连接SQL数据库实例详解 #### 一、概述 在Web开发中,数据库操作是不可或缺的一部分。ASP.NET作为一种流行的Web开发框架,提供了强大的功能来处理数据库操作。本篇文章将通过一个具体的示例来讲解如何在...

    SQL数据库通用访问类(ASP.NET)

    ### SQL数据库通用访问类在ASP.NET中的应用与详解 #### 引言 在现代Web开发中,特别是使用ASP.NET框架进行开发时,高效且安全地访问数据库是项目成功的关键因素之一。本文将深入探讨一个专门为ASP.NET设计的SQL...

    Asp.Net数据库帮助类 SQLHelper.cs

    《Asp.Net数据库帮助类SQLHelper.cs详解》 在Asp.Net开发中,数据库操作是不可或缺的一部分。为了简化代码,提高开发效率,开发者通常会创建一个数据库帮助类,如SQLHelper.cs,它封装了常见的数据库操作,使得在...

    【ASP.NET编程知识】.NET AppSettings与ConnectionStrings使用案例详解.docx

    在 ASP.NET 1.1 时期,AppSettings 节是用于存储数据库连接字符串的,但是这种做法有很多缺陷。例如,数据库连接字符串是明文存储的,容易被黑客攻击;另外,AppSettings 节中的配置信息是公共的,所有用户都可以...

    asp.net web.config设置详解

    `<appSettings>` 节用于存储应用程序的配置信息,这些信息通常用于配置应用程序的行为,如数据库连接字符串、API 密钥等。 - **示例代码**: ```xml ;userid=sa;password=;database=Info;"/> ``` - ...

    asp.net手动备份数据库

    ### ASP.NET手动备份数据库知识点详解 #### 一、ASP.NET环境下数据库备份的重要性及应用场景 在ASP.NET应用程序开发中,数据库备份是一项重要的维护工作。通过备份,可以确保在数据丢失或损坏的情况下能够快速恢复...

    SQL Server asp.net数据库安装程序代码

    在本案例中,"SQL Server asp.net数据库安装程序代码"可能是用C#编写的,用于帮助开发者快速部署和配置SQL Server环境,并可能包含创建数据库、设置用户权限、初始化数据等步骤。 【C#】 C#是一种面向对象的编程...

    Asp.net连接各类数据库

    ### ASP.NET 连接各类数据库知识点详解 #### 一、C#连接Access数据库 在ASP.NET应用程序中,连接Access数据库通常使用OLE DB提供程序。以下是对连接过程的详细解析: **1. 导入必要的命名空间** ```csharp using...

    ASP.NET连接mysql

    通过以上知识点的详细解析,我们可以看到ASP.NET与MySQL的整合不仅限于简单的连接操作,而是涉及到了数据接口的选择、连接字符串的配置、核心类的使用以及具体的数据操作流程。这种整合为开发者提供了强大的数据处理...

    Asp.Net、Ado.net 数据库编程超级攻略

    其中`strQuery`表示SQL查询字符串,`myConnection`是一个已打开的数据库连接对象。 - **设置Command属性**: - `CommandText`:获取或设置Command对象使用的命令文本。 - `CommandType`:指定命令的类型,如`...

Global site tag (gtag.js) - Google Analytics