Connect between visual and remote oracle

By installing the Oracle 10G drivers. Ask your Oracle DBA for the installer.

It has been many years since I messed with ADO.Net but I think you need to use Oracle OleDB or ODBC client drivers.  Oracle doesn't offer the 10g drivers for download any more but the 11g drivers should connect to a 10g database without problem.

If you must have the 10g drivers, you can contact Oracle Support and see if they can provide them for you.

When you say you've tried 11g without success, define that.  Did your app not locate the driver?  Did it compile fine and just not connect to the database?  Did your keyboard catch fire?  

Please provide more detailed information.

thank you my bro ..
when step for open connection (con.open) this message appear

An exception of type 'Oracle.ManagedDataAccess.Client.OracleException' occurred in Oracle.ManagedDataAccess.dll but was not handled in user code

Additional information: External component has thrown an exception

The Oracle Managed Driver is ODP.Net.  Going form memory the Managed Client was new in 12c.  I don't think a 12c driver will connect to a 10g database.

You mentioned you needed an ADO connection.  If you can use ODP.Net, I would suggest the 11g Unmanaged ODP.Net.

Nice ..
I need only to  ODP.Net 11 ??
or need other tool , or need change setting in my machine or in server ??

I cannot say what you need.  I don't have your requirements.  You said you needed ADO.  If you can use ODP.Net, I would strongly encourage you to do so.

If you have to connect to a 10g database, I believe you need the 11g drivers.  I don't think I've seen any 12g drivers that can connect to a 10g database but I haven't personally tried them all.

Oracle driver installations can be complex. Thus ask your DBA for the correct (supported) drivers and their possible manual setup.

I Tried By ODP.NET 11 ..
Downloaded From here

http://www.oracle.com/technetwork/topics/dotnet/downloads/odacdev-4242174.html

 but shows this error >>

An exception of type 'Oracle.DataAccess.Client.OracleException' occurred in Oracle.DataAccess.dll but was not handled in user code

Additional information: External component has thrown an exception.

please help me .. and i am sorry ..

OK, it looks like there is a problem in your code or some other "External component".

The ODAC used to come with example code.  I would try a really simple example like a 'select sysdate from dual' and make sure you can connect to the 10g database.  If that also fails, it might be that the 11.2 database cannot even connect to the 10g database you have.

hmm, ask your Oracle DBA..