Weird Import Export Wizard behaviour

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  May 2, 2007 at 12:55 pm

  #119852

  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?

• Vabs

  Grasshopper

  Points: 16

  More actions

  July 25, 2007 at 11:17 pm

  #722481

  I am too getting the same error..

   

  Please suggest

• Gogula G. Aryalingam

  SSCrazy

  Points: 2688

  More actions

  July 26, 2007 at 12:01 am

  #722485

  Hi,

  Does your password contain punctuation symbols (ideally a semicolon ";")? If so try supplying your password within double quotes.

  Let me know if it works.