Monday, March 12, 2012

Import Data from Oracle

I am using Import and Export wizard and seeing a very weird behaviour.

I am able to choose 'Microsoft OLE DB Provider for Oralce' and provide server name, username/ password. The test connection results in a success. However when I try to move to next window/page by clicking next I get invalid oracle error ora-01017 - invalid username/ password.

what is going on here?

Have you set the Save Password checkbox?

Thanks.

No comments:

Post a Comment