"easy to integrate with Oracle!" my foot...

Question

Every piece of information I've found has pointed me to use an OracleConnection object, and yet, no one tells me how to actually GET the oracle connection object -.-; it did one a single site, and I d/led it and installed it, but it STILL can't find the namespace. I have a general connection going on, but it can't connect (and every connectionstring example I've found on the internet and around the office doesn't work).


Apparently Provider isn't a valid key thing, neither is Data Provider, or any of the other myriad of things out there. I don't have oracle installed on my machine (trying to connect to a remote database) could that be the problem? Here's the string that I'm using right now (the one that actually attempts to execute...): Data Source=<TNS name>;User Id=<username>;Password=<password>;