原创力文档- 1、原创力文档（book118）网站文档一经付费（服务费），不意味着购买了该文档的版权，仅供个人/单位学习、研究之用，不得用于商业用途，未经授权，严禁复制、发行、汇编、翻译或者网络传播等，侵权必究。。
- 2、本站所有内容均由合作方或网友上传，本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺！文档内容仅供研究参考，付费前请自行鉴别。如您付费，意味着您自己接受本站规则且自行承担风险，本站不退款、不进行额外附加服务；查看《如何避免下载的几个坑》。如果您已付费下载过本站文档，您可以点击 这里二次下载。
- 3、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等，请点击“版权申诉”（推荐），也可以打举报电话：400-050-0827(电话支持时间：9:00-18:30)。
查看更多
数据库连接串大
数据库连接串大全
得道多助，失道寡助。花径不曾缘客扫，蓬门今始为君开。兴酣落笔摇五岳，诗成笑傲凌沧海。近朱者赤，近墨者黑。春风知别苦，不遣柳条青。ASE .NET Data Provider
MySQLDirect .NET Data Provider
ODBC .NET Data Provider
OLE DB .NET Data Provider
Oracle .NET Data Provider - From Microsoft
Oracle .NET Data Provider - From Oracle
OraDirect .NET Data Provider
PostgreSQLDirect .NET Data Provider
SQL Server .NET Data Provider
Adaptive Server Enterprise (ASE) .NET Data Provider
Sybase.Data.AseClient
Using C#
using Sybase.Data.AseClient;
...
AseConnection oAseConn = new AseConnection();
oAseConn.ConnectionString = Data Source=(local); +
Initial Catalog=myDatabaseName; +
User ID=myUsername; +
Password=myPassword
oAseConn.Open();
Using VB.NET
Imports System.Data.AseClient
...
Dim oAseConn As AseConnection = New AseConnection()
oAseConn.ConnectionString = Data Source=(local); _
Initial Catalog=myDatabaseName; _
User ID=myUsername; _
Password=myPassword
oAseConn.Open()
MySQLDirect .NET Data Provider
CoreLab.MySql
The MySQLDirect .NET Data Provider is an add-on component to the
.NET Framework that allows you to access the MySQL database using
native MySQL network protocol or MySQL client, without going through
OLE DB or ODBC.
Using C#
using CoreLab.MySql;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = User ID=myUsername; +
Password=myPassword; +
Host=localhost; +
Port=3306; +
Database=myDatabaseName; +
Direct=true; +
Protocol=TCP; +
Compress=false; +
Pooling=true; +
Min Pool Size=0; +
Max Pool Size=100; +
Connection Lifetime=0;
oMySqlConn.Open();
Using VB.NET
Imports CoreLab.MySql
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = User ID=myUsername; _
Password=myPassword; _
Host=localhost; _
Port=3306; _
Database=myDatabaseName; _
Direct=true; _
Protocol=TCP; _
Compress=false; _
Pooling=true; _
Min Pool Size=0; _
Max Pool Size=100; _
Connection Lifetime=0
oMySqlConn.Open()
ODBC .NET Data Provider
System.Data.ODBC
The ODBC .NET Data Provider is an add-on
文档评论（0）