Platform main database support type and configuration description

1. Types supported by the primary database:
platform Base database can only be used in three kinds: sqlserver9,oracle,oracle11g, for example, can use three different drivers to connect different databases,
650) this.width=650; "id=" Aimg_dqjku "class=" Zoom "width=" + "height=" "border=" 0 "src=" http://plat.delit.cn/data/ Attachment/forum/201510/10/182033eb79ajs3a51rb899.png.thumb.jpg "style=" Color:rgb (68,68,68); Font-family:Tahoma, Helvetica, SimSun, Sans-serif;font-size:14px;line-height:21px;white-space:normal;background-color:rgb ( 255,255,255); "/> 
three different drivers are described below:SqlServer9:A SQL Server database for connecting SqlServer2005, SqlServer2008, and newer versions, which is stable and reliable with Microsoft-provided drivers.


Oracle: Can be used to connect all versions of Oracle databases,used to be. NET provides the Oracle driver, which is the driver of Microsoft for Oracle, which uses the driver's namespace as "System.Data.OracleClient".
first, it has the advantage of being able to connect to all Oracle versions above Oracle8.1.7, so it's easy to use, and we've set it up later, regardless of Oracle version.
The disadvantage is that the speed is slow, and there are some bugs, some complex SQL statements, the result of execution is different from the Oracle itself, of course, this is very few, but can not be ruled out. Microsoft has given up support and is no longer updated. SoNot recommendedthis way.
oracle11g:
Oracle Database for connection to Oracle 11.1.7 and later versions,This is also ourRecommendedis the drive that Oracle writes to. NET, with the advantages of fast speed, accurate query, and high efficiency. There are few bugs and they are constantly being updated. But based onOracle11.1.7to be used in future versions. Compared with the Microsoft driver, it has a significant efficiency boost.
when using this driver, it is generally necessary to configure the Oracle.DataAccess.dll version, we need to find the Oracle installation directoryOracle.DataAccess.dll file, right-view its version, assuming the Oracle installation address is D, the file address is:D:\app\Administrator\product\11.2.0\dbhome_1\ODP.NET\bin\2.x
650) this.width=650; "id=" aimg_718 "src=" http://bbs.delit.cn/data/attachment/forum/201512/10/ 090743beo32qqlgoi0eeq2.png.thumb.jpg "width=" "height=" "alt=" 090743beo32qqlgoi0eeq2.png.thumb.jpg "/>"
after you see the version, if the version is not2.112.1.0, you need to configure the version number in the current environment in the Web. config file as follows:
<runtime>
<assemblybinding xmlns= "Urn:schemas-microsoft-com:asm.v1" >
<dependentAssembly>
<assemblyidentity name= "oracle.dataaccess" publickeytoken= "89b483f429c47342" culture= "neutral"/>
<bindingredirect oldversion= "2.112.1.0" newversion= "2.111.7.0 "/>
</dependentAssembly>
</assemblyBinding>
</runtime>

depending on the file version number you see, configurenewversionthe value,Add the code to the Configuration tab in the Web. config file.

We recommend that you use the Oracle driver if you are using an Oracle database, if the version is 11.1.7, and if the version is Oracle11.1.7 and later, use oracle11g to take advantage of the performance of the platform using Oracle's own drive.

Original address: http://bbs.delit.cn/thread-449-1-1.html

Reprint please specify the source:

Author: metric Technology http://www.delit.cn

Platform primary database support types and configuration instructions