I can see the oracle provider under the providers list and also I gave permission to the oracle folders to the sql service account and my account, even then I am still getting the same error. I do'nt know what else to do to resolve this error. Thanks.