System. Data. OracleClient. OracleConnection expired, oracleconnection

System. Data. OracleClient. OracleConnection expired, oracleconnection

The solution is as follows:

1. Set the originalUsing System. Data. OracleClient;Remove

2. Find oracle. DataAccess. dll in the Oracle installation directory to add reference:Using Oracle. DataAccess. Client;

If oracle 10g is installed, no dll is registered in Visual Studio and cannot be found when adding references. The default value of 11g is registered.

You can useFile SearchGo to the oracle installation directory and find,

Tip: If oracle is installed in the root directory of drive D, the path of the dll file is as follows:

D: \ oracle \ product \ 10.2.0 \ client_1 \ ODP. NET \ bin \ 1.x(Client)

D: \ oracle \ product \ 10.2.0 \ db_1 \ ODP. NET \ bin \ 1.x(Server)

3.Connection stringIf user = xxx is useful, change it to user id = xxx.