I'm experiencing some trouble with the manage provider and I can't seem to figure out what's causing the issue.
At first, the Managed Provider seemed to be a drop in replacement for the Unmanaged Provider. However, when we moved some code to our testing environments, the application started failing with a 'Logon Denied' error.
Our dev machines are 64 bit Win 7 and our test machines are Win 2008 R2. The DEV machines do not have any trouble connecting to the database with the identical connection string used in the test environment. I can connect to the database using sql plus with the connection string used in the application.
I'm at a loss on how to trouble shoot this.
Thanks.
Jon