For accessing Oracle XE Database in the Visual Studio, do I have to Install Oracle Data Acess Components(ODAC)
and Microsoft Oracle .NET Data Provider(ODP) both, or only the ODP will suffice?

 Hi,

Have a look at this URL

http://www.oracle.com/technology/tech/dotnet/tools/index.html

Regards

This redirects me to Oracle Data Access Components, which I mentioned earlier.

I have already installed this but stuck in executing the scripts which is the last part.

When I execute the script one by one from Oracle XE interface, it ignores the statement where other script is referenced.

How can I execute all the scripts at one go? OR, how do I run the script that the referencing statements are not ignored.