各种数据库的连接字符串

最新推荐文章于 2022-09-27 10:48:31 发布
最新推荐文章于 2022-09-27 10:48:31 发布
阅读量175 收藏 1
点赞数
文章标签： 数据库 c# 网络
原文链接：http://www.cnblogs.com/shuibi/p/6566127.html
版权
各种数据库的连接字符串

ADO.NET连接字符串大全

ADO.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 BasicUsing 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 Source=dbName@serverName; 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; dbq=@dbname"
OLD DB
标准:"Provider=PervasiveOLEDB; Data Source=C:\path"
　
UDL
UDL
UDL"File Name=c:\myDataLink.udl;"
 
 
 
好文要顶 关注成功  收藏该文   
 
 
关注成功
0
0
 
 
 
« 上一篇： sql每月的数据(转)
» 下一篇： Jquery mouseover()和mouseenter的区别(转自w3school)
posted on  2012-12-28 09:49 微澜 阅读(2693) 评论(0) 编辑 收藏

 

转载于:https://www.cnblogs.com/shuibi/p/6566127.html

weixin_30415801
关注
ASP.NET web.config中数据库连接字符串connectionStrings节的配置方法
10-27
在web.config中，节是用来定义数据库连接字符串的，这允许开发者配置和管理网站与其数据库之间的连接。 在配置节时，可以采用不同的方式，具体取决于数据库的位置（本地或远程）、类型（如SQL Server、SQL Server ...
EF 配置Oracle数据库数据库连接字符串的实例
09-09
当使用EF与Oracle数据库配合时，配置数据库连接字符串是至关重要的步骤。本文将详细解释如何在EF中配置Oracle数据库的连接字符串。 首先，要使用EF与Oracle数据库进行交互，我们需要安装相关的Oracle提供程序。这...
各类数据库连接字符串
zben000的专栏
10-11 118
MySQL: CONCAT() Oracle: CONCAT(), || SQL Server: + CONCAT() 的语法如下： CONCAT(字串1, 字串2, 字串3, ...): 将字串1、字串2、字串3，等字串连在一起。请注意，Oracle的CONCAT()只允许两个参数；换言之，一次只能将两个字串串连起来。不过，在Oracle中，我们可以用'||'来一次串连多个字串...
各种数据库连接字符串
05-08 1004
Java数据库连接字符串 1、Oracle8/8i/9i数据库（thin模式） Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String   url="jdbc:oracle:thin:@localhost:1521:orcl";   //orcl为数据库的SID     String   user="t
连接各种数据库的连接字符串(java)
阳心的博客
07-05 1126
连接各种数据库的连接字符串(java) 1、Oracle8/8i/9i数据库（thin模式）    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();    String  url="jdbc:oracle:thin:@localho
mysql 数据库连接字符串_各种数据库的连接字符串
weixin_35353583的博客
01-18 577
SQL Server 2005SQL 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_...
常见的数据库连接字符串
Colin_RZL的博客
03-26 2197
记录下几种常见的数据库连接字符串,手打不容易，有帮助的话点个赞啊。 数据库类型 连接方式 连接字符串 Access ODBC “Driver={Microsoft Access Driver(*.mdb)}; Dbq=<\mdb file>; Uid=<\user name>; Pwd=<\password>;” Access OLEDB “Provider=Microsoft.Jet.OLEDB4.0; Data Source=<\mdb fi
asp.net 获取数据库连接字符串
10-20
本篇文章将详细解释如何在ASP.NET中获取数据库连接字符串，并提供相关的实现代码。 首先，我们需要引入`System.Configuration`命名空间，这是ASP.NET框架用于读取应用程序配置文件（如`web.config`）的关键组件。...
常见数据库——连接字符串列表
Koma的主页
09-26 896
数据库连接字符串列表点击类别，查看相应的连接字符串(本页仅支持IE浏览器): SQL Server  ODBC  Standard Security（标准的安全模式）:"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=myUsername;Pwd=myPassword;
数据库连接字符串
08-16 190
一、SQL Server ODBC 标准连接 Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 受信的连接 Dri...
Spring Boot 数据库版本管理入门
weixin_42073629的博客
04-28 2161
1. 概述 在我们的认知中，我们会使用 SVN 或 Git 进行代码的版本管理。但是，我们是否好奇过，数据库也是需要进行版本管理的呢？ 在每次发版的时候，我们可能都会对数据库的表结构进行新增和变更，又或者需要插入一些初始化的数据。而我们的环境不仅仅只有一套，一般来说会有 DEV、UAT、PRED、PROD 四套环境，会对应 DEV、UAT、PROD 三个数据库。 PRED 环境，一般连接 ...
数据库版本控制Flyway
背着小书包一路追寻梦想
10-24 4149
Flyway 目录 1. Flyway简介 2. SQL脚本命名规则 3. 添加maven依赖 4. 配置数据源信息 5. 新建脚本文件 6. 启动SpringBoot项目 7. Flyway常用配置 1. Flyway简介 Flayway是一款数据库版本控制管理工具，支持数据库版本自动升级，Migrations可以写成sql脚本，也可以写在java代码里；不仅支持Command Line和java api ，也支持Build构建工具和Spring boot，也可以在分布式环境..
java 数据库版本管理_Spring Boot 数据库版本管理Flyway
weixin_31650287的博客
02-28 839
在 Flyway 的官网 https://flywaydb.org/ 中，对自己的介绍是：Version control for your database.数据库的版本管理。Flyway 支持的数据库，主要是关系数据库。Flyway 提供了 SQL-based migrations 和 Java-based migrations 两种数据库变更方式。前者使用简单，无需编写 Java 代码。后者需...
Spring Boot中使用Flyway来管理数据库版本
一个有情怀的程序猿博客
07-29 616
久违了的Spring Boot系列，今天抽空更新一篇。去年写过很多篇关于数据访问的文章了，比如下面这些： 使用JdbcTemplate 使用Spring-data-jpa简化数据访问层（推荐） 多数据源配置（一）：JdbcTemplate 多数据源配置（二）：Spring-data-jpa 使用NoSQL数据库（一）：Redis 使用NoSQL数据库（二）：MongoDB 整合MyBatis MyBatis注解配置详解 使用事务管理 如果没有...
spring-cloud集成数据库版本迁移工具flyway
xinyi_java的博客
09-27 3107
Flyway实现数据库版本同步有两种方式，一种就是直接导包，通过配置文件使用，还有一种就是自定义的方式。
flyway数据库版本控制linux,Spring Boot 集成 Flyway 实现数据库版本控制
weixin_35934979的博客
05-04 298
在项目迭代开发中，难免会有更新数据库 Schema 的情形，好比添加新表、在表中增添字段或者删除字段等，那么当我对数据库举行一系列操作后，若何快速地在其他同事的电脑上同步？若何在测试/生产服务器上快速同步？每次发版的时刻，由于人人都可能有 sql 更改情形，这样就会有以下痛点：遗忘某些 sql 修改每个开发人员的 sql 的执行顺序问题重复更新需要手动去数据库执行剧本以上问题以及痛点可以通过 Fl...
Flyway 数据库脚本版本控制工具
心有猛虎细嗅蔷薇
01-22 5497
Flyway简介 Flyway是一个简单开源数据库版本控制器（约定大于配置），主要提供migrate、clean、info、validate、baseline、repair等命令。它支持SQL（PL/SQL、T-SQL）方式和Java方式，支持命令行客户端等，还提供一系列的插件支持（Maven、Gradle、SBT、ANT等）。 官方网站：https://flywaydb.org/ 概...
SpringBoot 04 集成Flyway实现数据库版本控制
Keep learing, and stay fast
01-28 3264
1. 为什么使用Flyway 最简单的一个项目是一个软件连接到一个数据库，但是大多数项目中我们不仅要处理我们开发环境的副本，还需要处理其他很多副本。例如：开发环境、测试环境、生产环境。想到数据库管理，我们立刻就能想到一系列问题 如何快速收集执行脚本的清单 执行的脚本总要人工执行，是否可以通过机器执行 执行的脚本是否已经在数据库执行过 执行的脚本是否全部在数据库中执行过 执行的脚本如何回退 如何初始化一个空数据库实例 Flywa...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值