.NET Data Provider

最新推荐文章于 2024-07-24 23:57:03 发布
最新推荐文章于 2024-07-24 23:57:03 发布
阅读量8.6k 收藏 3
点赞数
分类专栏： CSDN资料库 文章标签： .net microsoft vb.net sql server oracle database
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/naive1010/article/details/333431
版权
  •  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
  • The ASE .NET Data Provider is an add-on component to the .NET 1.1 Framework that allows you to access a Sybase Adaptive Server Enterprise (ASE) database.
    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()
    For more information, see:  ASE User's Guide
    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()
    For more information, see:   CoreLab's MySqlDirect .NET Data Provider
    The Open Database Connectivity (ODBC) .NET Data Provider is an add-on component to the .NET Framework. It provides access to native ODBC drivers the same way the OLE DB .NET Data Provider provides access to native OLE DB providers.
    Note: This technology is included in version 1.1 of the .NET Framework. You need only download this, if you are running version 1.0.
    For SQL Server ODBC Driver 
    ' VB.NET
    Imports System.Data.Odbc
    ...
    Dim oODBCConnection As OdbcConnection
    Dim sConnString As String = _
              "Driver={SQL Server};" & _
              "Server=MySQLServerName;" & _
              "Database=MyDatabaseName;" & _
              "Uid=MyUsername;" & _
              "Pwd=MyPassword"
    oODBCConnection = New Odbc.OdbcConnection(sConnString)
    oODBCConnection.Open()
    For Oracle ODBC Driver 
    ' VB.NET
    Imports System.Data.Odbc
    ...
    Dim oODBCConnection As OdbcConnection
    Dim sConnString As String = _
             "Driver={Microsoft ODBC for Oracle};" & _
             "Server=OracleServer.world;" & _
             "Uid=myUsername;" & _
             "Pwd=myPassword"
    oODBCConnection = New Odbc.OdbcConnection(sConnString)
    oODBCConnection.Open()
    For Access (JET) ODBC Driver 
    ' VB.NET
    Imports System.Data.Odbc
    ...
    Dim oODBCConnection As OdbcConnection
    Dim sConnString As String = _
             "Driver={Microsoft Access Driver (*.mdb)};" & _
             "Dbq=c:/somepath/mydb.mdb;" & _
             "Uid=Admin;" & _
             "Pwd="
    oODBCConnection = New Odbc.OdbcConnection(sConnString)
    oODBCConnection.Open()
    For Sybase System 11 ODBC Driver 
    ' VB.NET
    Imports System.Data.Odbc
    ...
    Dim oODBCConnection As OdbcConnection
    Dim sConnString As String = _
    		   "Driver={Sybase System 11};" & _
                       "SRVR=mySybaseServerName;" & _
                       "DB=myDatabaseName;" & _
                       "UID=myUsername;" & _
                       "PWD=myPassword"
    oODBCConnection = New OdbcConnection(sConnString)
    oODBCConnection.Open()
    For all other ODBC Drivers 
    ' VB.NET
    Imports System.Data.Odbc
    ...
    Dim oODBCConnection As OdbcConnection
    Dim sConnString As String = "Dsn=myDsn;" & _
                                    "Uid=myUsername;" & _
                                "Pwd=myPassword"
    oODBCConnection = New Odbc.OdbcConnection(sConnString)
    oODBCConnection.Open()
    For more information, see:  OdbcConnection Class and .NET Data Providers
    To view Microsoft KB articles related to OdbcConnection, click here 
    The Microsoft .NET Framework Data Provider for OLE DB allow you to use native OLE DB providers (e.g.  Microsoft.JET.OLEDB.4.0) through COM interop to enable data access. 
    The Microsoft .NET Framework Data Provider for OLE DB is included in both the 1.0 and 1.1 version of the .NET Framework. 
    For IBM AS/400 OLE DB Provider 
    ' VB.NET
    Imports System.Data.OleDb
    ...
    Dim oOleDbConnection As OleDbConnection
    Dim sConnString As String = _
               "Provider=IBMDA400.DataSource.1;" & _
               "Data source=myAS400DbName;" & _
               "User Id=myUsername;" & _
               "Password=myPassword"
    oOleDbConnection = New OleDb.OleDbConnection(sConnString)
    oOleDbConnection.Open()
    For JET OLE DB Provider 
    ' VB.NET
    Imports System.Data.OleDb
    ...
    Dim oOleDbConnection As OleDbConnection
    Dim sConnString As String = _
             "Provider=Microsoft.Jet.OLEDB.4.0;" & _
             "Data Source=C:/myPath/myJet.mdb;" & _
             "User ID=Admin;" & _
             "Password=" 
    oOleDbConnection = New OleDb.OleDbConnection(sConnString)
    oOleDbConnection.Open()
    For Oracle OLE DB Provider 
    ' VB.NET
    Imports System.Data.OleDb
    ...
    Dim oOleDbConnection As OleDbConnection
    Dim sConnString As String = _
             "Provider=OraOLEDB.Oracle;" & _
             "Data Source=MyOracleDB;" & _
             "User ID=myUsername;" & _
             "Password=myPassword" 
    oOleDbConnection = New OleDb.OleDbConnection(sConnString)
    oOleDbConnection.Open()
    For SQL Server OLE DB Provider 
    ' VB.NET
    Imports System.Data.OleDb
    ...
    Dim oOleDbConnection As OleDbConnection
    Dim sConnString As String = _
             "Provider=sqloledb;" & _ 
             "Data Source=myServerName;" & _
             "Initial Catalog=myDatabaseName;" & _
             "User Id=myUsername;" & _
             "Password=myPassword" 
    oOleDbConnection = New OleDb.OleDbConnection(sConnString)
    oOleDbConnection.Open()
    For Sybase ASE OLE DB Provider 
    ' VB.NET
    Imports System.Data.OleDb
    ...
    Dim oOleDbConnection As OleDbConnection
    Dim sConnString As String = _
             "Provider=Sybase ASE OLE DB Provider;" & _
             "Data Source=MyDataSourceName;" & _
             "Server Name=MyServerName;" & _
             "Database=MyDatabaseName;" & _
             "User ID=myUsername;" & _
             "Password=myPassword" 
    oOleDbConnection = New OleDb.OleDbConnection(sConnString)
    oOleDbConnection.Open()
    For more information, see:  OleDbConnection Class and .NET Data Providers
    To view Microsoft KB articles related to OleDbConnection, click here 
    The Microsoft .NET Framework Data Provider for Oracle is an add-on component to the .NET Framework 1.0 that provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software.
    Oracle 8i Release 3 (8.1.7) Client or later must be installed for this provider to function correctly.
    Note: This .NET Data Provider is included in version 1.1 of the .NET Framework. You need only download this, if you are running version 1.0.
    Using C#: 
    using System.Data.OracleClient;
     
    OracleConnection oOracleConn = new OracleConnection();
    oOracleConn.ConnectionString = "Data Source=Oracle8i;" +
                                   "Integrated Security=SSPI";
    oOracleConn.Open();
    Using VB.NET: 
    Imports System.Data.OracleClient

    Dim oOracleConn As OracleConnection = New OracleConnection()
    oOracleConn.ConnectionString = "Data Source=Oracle8i;" & _
                                   "Integrated Security=SSPI";
    oOracleConn.Open()
    For more information, see:   OracleConnection Class and .NET Data Providers
    To view Microsoft KB articles related to OracleConnection, click here 
    The Oracle .NET Framework Data Provider from Oracle is an add-on component to the .NET Framework.
    Using C# 
    using Oracle.DataAccess.Client;
    ...
    OracleConnection oOracleConn = new OracleConnection();
    oOracleConn.ConnectionString = "Data Source=MyOracleServerName;" +
                                   "Integrated Security=SSPI";
    oOracleConn.Open();
    Using VB.NET 
    Imports Oracle.DataAccess.Client
    ...
    Dim oOracleConn As OracleConnection = New OracleConnection()
    oOracleConn.ConnectionString = "Data Source=MyOracleServerName;" & _
                                   "Integrated Security=SSPI";
    oOracleConn.Open()
    For more information, see: Oracle Data Provider for .NET
    The OraDirect .NET Data Provider is an add-on component to the .NET
    Framework that provides access to an Oracle database using the Oracle
    Call Interface (OCI) as provided by Oracle Client software.

    Using C# 
    using CoreLab.Oracle;

    OracleConnection oOracleConn = new OracleConnection(); 
    oOracleConn.ConnectionString = "User ID=myUsername;" +
                                  "Password=myPassword;" +
                                  "Host=(local);" +
                                  "Pooling=true;" +
                                  "Min Pool Size=0;" +
                                  "Max Pool Size=100;" +
                                  "Connection Lifetime=0";
    oOracleConn.Open();

    Using VB.NET 
    Imports CoreLab.Oracle

    Dim oOracleConn As OracleConnection = New OracleConnection() 
    oOracleConn.ConnectionString = "User ID=myUsername;" & _
                                  "Password=myPassword;" & _
                                  "Host=(local);" & _
                                  "Pooling=true;" & _
                                  "Min Pool Size=0;" & _
                                  "Max Pool Size=100;" & _
                                  "Connection Lifetime=0"
    oOracleConn.Open()
    For more information, see:  OraDirect .NET Data Provider
    The MySQL .NET Native Provider is an add-on component to the .NET Framework that allows you to access the MySQL database through
     the native protocol, without going through OLE DB or ODBC.
    Using C# 
    using EID.MySqlClient;
    ...
    MySqlConnection oMySqlConn = new MySqlConnection();
    oMySqlConn.ConnectionString = "Data Source=(local);" +
                                  "Database=myDatabaseName;" +
                                  "User ID=myUsername;" +
                                  "Password=myPassword;" +
                                  "Command Logging=false";
    oMySqlConn.Open();
    Using VB.NET 
    Imports EID.MySqlClient
    ...
    Dim oMySqlConn As MySqlConnection = New MySqlConnection()
    oMySqlConn.ConnectionString = "Data Source=(local);"  & _
                                  "Database=myDatabaseName;"  & _
                                  "User ID=myUsername;"  & _
                                  "Password=myPassword;"  & _
                                  "Command Logging=false"
    oMySqlConn.Open()
    For more information, see:   EID's MySQL ADO.NET native provider
    The PostgreSQLDirect .NET Data Provider is an add-on component to the
    .NET Framework that allows you to access the PostgreSQL database using
    native message-based protocol, without going through OLE DB or ODBC.

    Using C# 
    using CoreLab.PostgreSql;

    PgSqlConnection oPgSqlConn = new PgSqlConnection(); 
    oPgSqlConn.ConnectionString = "User ID=myUsername;" +
                                  "Password=myPassword;" +
                                  "Host=localhost;" +
                                  "Port=5432;" +
                                  "Database=myDatabaseName;" +
                                  "Pooling=true;" +
                                  "Min Pool Size=0;" +
                                  "Max Pool Size=100;" +
                                  "Connection Lifetime=0";
    oPgSqlConn.Open();


    Using VB.NET 
    Imports CoreLab.PostgreSql

    Dim oPgSqlConn As PgSqlConnection = New PgSqlConnection() 
    oPgSqlConn.ConnectionString = "User ID=myUsername;" & _
                                  "Password=myPassword;" & _
                                  "Host=localhost;" & _
                                  "Port=5432;" & _
                                  "Database=myDatabaseName;" & _
                                  "Pooling=true;" & _
                                  "Min Pool Size=0;" & _
                                  "Max Pool Size=100;" & _
                                  "Connection Lifetime=0"
    oPgSqlConn.Open()
    For more information, see:   PostgreSQLDirect .NET Data Provider
    The SQL Server .NET Data Provide allows you to connect to a Microsoft SQL Server 7.0 or 2000 database.  For Microsoft SQL Server 6.5 or earlier, use the OLE DB .NET Data Provider with  the "SQL Server OLE DB Provider" (SQLOLEDB).
    Note: The SQL Server .NET Data Provider knows which data provider it is.  Hence the "provider=" part of the connection string is not needed. 
    Using C#: 
    using System.Data.SqlClient;
    ...
    SqlConnection oSQLConn = new SqlConnection();
    oSQLConn.ConnectionString = "Data Source=(local);" +
                                "Initial Catalog=myDatabaseName;" +
                                "Integrated Security=SSPI";
    oSQLConn.Open();
    Using VB.NET: 
    Imports System.Data.SqlClient
    ...
    Dim oSQLConn As SqlConnection = New SqlConnection()
    oSQLConn.ConnectionString = "Data Source=(local);" & _
                                "Initial Catalog=myDatabaseName;" & _
                                "Integrated Security=SSPI"
    oSQLConn.Open()
    If connection to a remote server (via IP address): 
    oSQLConn.ConnectionString = "Network Library=DBMSSOCN;" & _
                                "Data Source=xxx.xxx.xxx.xxx,1433;" & _
                                "Initial Catalog=myDatabaseName;" & _
                                "User ID=myUsername;" & _
                                "Pas sword=myPassword"
    Where: 
    - "Network Library=DBMSSOCN" tells SqlConnection to use TCP/IP Q238949
    - xxx.xxx.xxx.xxx is an IP address.  
    - 1433 is the default port number for SQL Server.  Q269882 and Q287932
    - You can also add " Encrypt=yes" for encryption 
     
    For more information, see:  SqlConnection Class, Q308656, and .NET Data Providers
    Note: Microsoft SQLXML Managed Classes exposes the functionality of SQLXML inside the Microsoft .NET Framework.
    To view Microsoft KB articles related to SQLClient, click here 
naive1010
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
.net framework data provider for mysql_如何添加".Net Framework Data Provider for MySQL"配置信息到目标主机中？...
weixin_31556371的博客
02-04 519
在使用Entity Framework开发数据业务系统时，使用了MySQL数据库，ADO.NET driver for MySQL使用官网http://www.mysql.com/downloads/connector/net/中下载的提供程序，在开发环境中安装该提供程序后，该安装程序将修改系统配置文件“C:\Windows\Microsoft.NET\Framework\v2.0.50727\C...
mysql data provider_Data Provider 中没有.net framework Data provider for Mysql 的解决方法
weixin_32475641的博客
01-27 787
近来做的一个项目中，数据库用的是 MySql， 而在项目使用 Entity Data Model 来做数据服务层，可是在项目中添加 Data Entty Model 时，一般我们都会选择从数据库中直接生成，可是在选择Data Provider 时，就是没有 .net framework Data provider for Mysql, 里面默认就只有一个.netframework Data pr...
SQL1159 Initialization error with DB2 .NET Data Provider, reason code 10.
匿_名_用_户的专栏
06-12 2574
问题： SQL1159 Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 10.5.10, Process Owner: IIS APPXXX\XXX_SR 解决： 参考下面的链接http://www-01.ibm.com/support/docview.wss?uid=swg2141...
C# DbProviderFactories工厂类使用。【报错解决】找不到请求的 .Net Framework Data Provider。可能没有安装
zgscwxd的博客
05-17 243
C#【报错解决】找不到请求的Net Framework Data ProVider。可能没有安装。
.Net Framework Data Provider
zsyqwe的博客
04-12 1284
System.ArgumentException:“找不到请求的 .Net Framework Data Provider。可能没有安装 报此错误可能是电脑的mysql 的 provide没装 百度搜索mysql的Connector/NET 安装即可
.net framework data provider for mysql,codesmith连接Mysql提示“找不到请求的 .Net Framework Data Provider。可能没有安装...
weixin_30635707的博客
03-12 583
１，首先需要将MySql.Data.dll复制到codesmith安装目录下bin文件夹下，注意dll的版本２，其次因为codesmith7采用的是.net4.0的配置文件，(64位系统)找到C:\Windows\Microsoft.Net\Framework64\v4.0.30319\Config\machine.config在其中的DbProviderFactories节点下添加注意其中的版本...
对于ado.net dataProvider的介绍
12-18 151
学习刘皓的 ADO.NET入门教程（二）了解.NET数据提供程序 而来 这篇文章很一般，主要是对dataProvider做了个简单的介绍。因为在该系列文章中提到，ado.net主要有两部分 dataPrvider和dataset。所以本文介绍dataProvider。 重申dataprovider主要有Connetion、Command、SqlDataAdapter、SqlDataR...
IP*Works! ADO.NET Data Provider
weixin_30895603的博客
07-21 101
IP*Works! ADO.NET Data Provider Use SQL queries and native .NET data objects for Internetdevelopment. The IP*Works! ADO.NET Data Provider implements a standard Microsoft .NET Data Provider enablin...
金仓数据库KingbaseES客户端编程接口指南-ado.net（4. .NET Data Provider 驱动介绍与应用程序结构说明）
arthemis_14的博客
09-02 809
本章节介绍KingbaseES的 .NET 驱动提供的几个基本功能类。KdbndpConnection 类KdbndpCommand 类KdbndpParameter 类KdbndpDataAdapter 类KdbndpTransaction 类。
SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2；reason code 10
swanabin的专栏
07-23 6009
转自VC错误:http://www.vcerror.com/?p=1861 问题描述： 开发环境：visual studio 2010 数据库： IBM db2 9.7  for windows reason code 2错误信息： SQL1159  Initialization error with DB2 .NET Data Provider, reason code 2,
.net framework data provider for mysql_Sqlite数据库 找不到请求的 .Net Framework Data Provider。可能没有安装...
weixin_34751996的博客
02-15 1114
解决方法 在web.config里面添加注意:Version后面的 1.0.66.0 要根据你安装的sqlite的版本来写.所有的web.config如下ASP.NET项目使用MYSQL数据库部署到IIS服务器找不到请求的.Net Framework Data Provider解决方案使用MySQL开发过程中在自己的机器上跑项目是没有问题的,但在实际部...
HSQL ADO.Net Data Provider-开源
08-01
《HSQL ADO.NET数据提供程序：开源的力量与实践》 在信息技术领域，开源软件以其透明性、灵活性和社区支持的优势，逐渐成为开发者的首选。本文将深入探讨一个完全用C#编写的开源项目——HSQL数据库引擎的ADO.NET...
.Net Data Provider for MySQL-开源
05-03
MySQLDotNet是MySQL的100％.Net兼容数据提供程序。 它实现了所有必需的类，例如Connection，Command，DataReader和DataAdapter。 功能包括将类型自动转换为.Net数据类型，事务，Unicode和Blob支持。
Microsoft .NET Data Provider for mySAP Business Suite
11-22
除了使用SAP.NetConnect访问SAP数据外，也可以使用这个接口进行操作，同时此访问接口可以创建可与 mySAP Business Suite 解决方案连接的 Integration Services 包，然后执行可通过支持界面访问数据的命令。
Firebird.NET (a .net data provider)-开源
07-09
他们应该考虑切换到官方支持的驱动，如Firebird ADO.NET Provider（通常称为FirebirdClient），以获得更好的性能、稳定性和安全性。官方驱动通常会及时跟进Firebird数据库的最新改进，包括新的SQL语法、性能优化和...
错误找不到请求的 .Net Framework Data Provider。可能没有安装.rar
07-06
在IT行业中，开发和部署Web应用程序时，可能会遇到各种错误，其中之一是“错误找不到请求的 .Net Framework Data Provider。可能没有安装”。这个问题通常出现在使用IIS（Internet Information Services）作为Web...
C#测试控制台程序调用Quartz.NET的基本用法
最新发布
gc_2299的博客
07-24 487
学习Quartz.NET在控制台程序中的基本用法
硅纪元视角 | 语音克隆突破：微软VALL-E 2，Deepfake新纪元！
guijiyuantech的博客
07-24 684
此外，VALL-E 2 的创新技术，如重复感知采样和分组代码建模，为提高语音合成的稳定性和效率提供了新的解决方案，这可能对其他领域的语音处理技术产生深远影响。同时，开源AI模型在数据隐私和安全性方面的优势，也为用户提供了更多的选择和保障。综上所述，AI Playground的推出不仅为用户提供了一个功能丰富的AI应用平台，也为AI技术的进一步发展和应用提供了广阔的空间和可能性。总体来看，AI技术在巴黎奥运会的广泛应用，不仅提升了赛事的专业性和观赏性，也为体育赛事的智能化、个性化发展提供了新的思路和方向。
“微软蓝屏”事件暴露了网络安全哪些问题？
数字人生
07-23 918
微软蓝屏事件是对全球网络安全的一次深刻警示。面对日益复杂的网络安全威胁，我们必须采取更加积极和有效的措施，构建一个更加稳固和安全的网络环境。通过不断的技术创新和制度完善，我们能够更好地保护我们的数字世界，确保其安全、稳定和可靠。这篇文章深入分析了微软蓝屏事件暴露的网络安全问题，并提出了具体的应对策略和建议，旨在为构建更加稳固和安全的网络环境提供参考和启示。希望这些内容能为网络安全领域的进一步发展贡献一份力量。
ASP.NET 3.5: 使用ODBC.NET Data Provider访问数据库
"ASP.NET 3.5第10章详细探讨了如何访问除SQL Server之外的其他数据源，特别是利用ODBC.NET Data Provider来实现这一目标。本章内容主要涉及ODBC的基础概念、ODBC.NET Data Provider的工作原理以及如何使用它来连接和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值