Connect to the oracle server without installing the oracle client (NOTE: For odp.net)

A few days ago, I was studying how to access oracle without installing the oracle client and synchronize the data in it to the local SQL Server database.

Preparation: First, you have to have the following. dll. This is for oracle10g. If it is a later version, use 10g or above.

Oci. dll, ocijdbc10.dll, ociw32.dll, orannzsbb10.dll, oraocci10.dll, oraociei10.dll, System. Data. OracleClient. dll

The last dll I used was Oracle. dataacess. dll at first, and then I always reported initialization failure because it was probably due to a local environment problem. I am going to investigate it when I have time. I put the above dll on csdn, and the address is at the end.

Below are some code in the demo:

Orcle connection object OracleConnection conn = connstr = (conn = OracleExecuteDataSet ExecuteDataSet (optional text, DataSet ExecuteDataSet (optional text, CommandType optional type, ====== (conn! = PrepareOracleCommand PrepareCommand (OracleCommand command, OracleConnection connection, CommandType initialize type, (connection. State! ==== (CommandParameters! = (OracleParameter parm View Code

The operation is basically the same as that of. net. There is nothing to say about it. The main thing is the above dll, which is very important.

Http://download.csdn.net/download/pcbzw/7097097 (csdn)