ODP.net and Oracle 11g

just an update on my progress. It seems that doesn't matter which vers. of ODP.net you install it will always have problems with SQLDataSource, it simly doesn't work, so if you try any other DataSource like ObjectDataSource with DataSet or other implementation, it's working and parametrized too but remember to use :PARAM , instead of @PARAM . Jusst a piece of advice: remember to condifure your Network/Admin .ora files properly otherwise it won't work. The way i did it was to install the v10 over the 9 then the 11g , then configure it. And this time it worked , no Data provider internal error(-3000) , but still with ORA-01036: illegal variable name/number' on SQLDataSource, so my advice don't uset it , never, just for demos, for a real project , think different.

Anyone has a different oppinion on how to do things with oracle differently ?

The first thing I'd do is make sure you get the latest Visual Studio tools package called "ODAC [version] with Oracle Developer Tools for Visual Studio". Currently, it's located at http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html but that may change years from now.

Then I'd install ALL of the components from your newly downloaded installer. You really don't need to worry about the disk space on your average developer's desktop, as it's only around a 230 MB download as of today. (Version 11.2.0.2.1 is current at the time of this writing.)