oracle 10g with visual studio express 2005

have Visual studio express. I want to connection to oracle 10g express edition. How can i do that. I am looking at Oledb oracle.
ODP.NET does not seems to work with visual studio exprees. there fore i would like to see the code for
oledb to connect to oracle. like
connectionstring,
 connection command and dataadapter

any suggestions would be helpful.
or code for visual studio 2005 would be ok too
malik1977Asked:
Who is Participating?
 
Bob LearnedConnect With a Mentor Commented:
Did you add a reference to the Oracle.DataAccess.dll to the project?

Bob
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
malik1977Author Commented:
thanks for the links. But i am specifically looking to for code to connect

Vs.net form (formview) to oracle 10g. ODP.net does not seem to work with express version

i am looking for oledb oracle code

thanks
0
 
actonwangCommented:
0
 
actonwangCommented:
or this:

http://www.stanford.edu/dept/itss/docs/oracle/10g/win.101/b10115/using.htm#sthref48

scroll down to bottom and there is a detailed example specifally for oledb 10.
0
 
Bob LearnedCommented:
What version of ODP.NET did you try?  What indications are you getting that it is not working?

Bob
0
 
malik1977Author Commented:
BOB
I can connect to oracle database in database explorer in Vs  2005 webdeveloper express edition
i just want to connect in the code behind using
system.Data.oracleClient

and oraclecommand, oracaleadapter and oracledataaset.

it does not seem to recognize the name spaces any solution to that
0
 
malik1977Author Commented:
now i did and it works. i thought you only do that with vs 203 .

thanks
0
All Courses

From novice to tech pro — start learning today.