How to connect with Oracle Server on VB.NET using IDbCommand ?

Hi all,

i will have to work with Oracle database with VB.NET

i use IDbConnection, IDbCommand and IDbDataAdapter to connect with all MSSQL and MSACCESS database without any problem
but will the command will work with Oracle server? or will i have to create ODBC link? or something like that?

i don't have any oracle server installed yet... so i cannot test....


please help me,

regards
LVL 2
Dnx_7Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jorge PaulinoConnect With a Mentor IT Pro/DeveloperCommented:
With VB.NET you can you the System.Data.OracleClient. I think that's the easy and the best way.

Have a look of this post from navstar16 http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21822516.html

0
 
Dnx_7Author Commented:
Yes i know that oracleconnection is the best way as the sqlconnection is the best way to connect with sql server but in our enterprise, we have to use idbcommand, idbconnection and don't you think is possible or i have to use oracleconnection (no other way...)

regards
0
 
Dnx_7Author Commented:
sorry, i just read the post, let me answer later

thank you jpaulino

regards
0
All Courses

From novice to tech pro — start learning today.