winform 远程连接oracle方式 弄了两天终于成功！！

//需要装oracle客户端连接字符串
provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=**;Data Source=192.168.0.10;Extended Properties='';Password=**

//不需要装oracle客户端连接字符串
provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.10)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=sh803)));User ID=**;Password=**

 

确保几点

1、ping server_IP pass

2、telnet server_IP 1521 pass

3、use OleDbConnection way

4、Oracle Data Provider for .NET Help(必须) 

 

 

OK!goog luck.....