C # connecting Oracle System.Data.Oracleclient requires Oracle client software Version8.1.7 or later issues:
Start WebService the connection string in Web. config in the 32-bit system oracle10g Library is:
<add name= "emrconnectionstring" connectionstring= "Data source=test1; User Id=test1; Password=test1; Unicode=true "Providername=" System.Data.OracleClient "/><!----System.Data.OracleClient connection mode----! >
<add name= "firstconnection" connectionstring= "Provider=msdaora;data source=test; User id=test; Password=test; Persist Security info=true "providername=" System.Data.OleDb "/> <!---Note: Provider=msdaora is for 32-bit operating systems, If 64-bit operating system needs to use Provider=oraoledb.oracle--! >
When upgrading to a 64-bit operating system and oracle11g, then use the above method to connect the "System.Data.Oracleclient requires Oracle client software Version8.1.7 or a later version of the problem", specifically, the following:
① follow the permissions as modified:
2. Modify the connection string
<add name= "emrconnectionstring" connectionstring= "Data source=test1; User Id=test1; Password=test1; Unicode=true "Providername=" System.Data.OracleClient "/><!----System.Data.OracleClient connection mode----! >
<add name= "firstconnection" connectionstring= "Provider=oraoledb.oracle;data source=test; User id=test; Password=test; Persist Security info=true "providername=" System.Data.OleDb "/> <!---Note: Provider=msdaora is for 32-bit operating systems, If 64-bit operating system needs to use Provider=oraoledb.oracle--! >
System.Data.Oracleclient requires Oracle client software Version8.1.7 or later issues