SQL Server 2005 Import and Export - ORA-01017

Question

Post reply

SQL Server 2005 Import and Export - ORA-01017

Amith Vemuganti

Ten Centuries

Points: 1350
More actions
February 21, 2008 at 9:07 am

#186844

Hello All,
I'm trying to load data into a table in SQL Server 2005 schema from Oracle schema using DTSWizard.
Following is the details:
Source: Oracle 10g
Destination: MS SQL Server 2005
Data Source: Microsoft OLE DB Provider for Oracle
I have given all the details correctly in Data Link Properties window (Datasource, User, Password) and I got "Test Connection Succeeded" message when I clicked on "Test Connection" Button.
I left the two check boxes blank, Blank Password and Allow Saving Password, and proceeded further and I get the following error
ORA-01017: invalid username/password; logon denied (Microsoft OLE DB Provider for Oracle). However, When I check the Allow Saving Password box, I could load the data succesfully.
Can any one help me in knowing the exact reason for this behaviour.
Your help is greatly appreciated.
Thanks in advance,
-Amith

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLdevotee SSCarpal Tunnel Points: 4820 More actions · Answer 1

You mean you did not have username and password at all when it said test connection success?

[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

Amith Vemuganti Ten Centuries Points: 1350 More actions · Answer 2

I gave all the details username, password, and Data Source when it said Test Connection Success.

Thanks,

-Amith Vemuganti

walkercp SSC Enthusiast Points: 159 More actions · Answer 3

Same issue for me. I can connect via sqlpus on my server to the ORacle server database OK

Running SQL Server 2005 SP2. and ORACLE 10.2 server and client. on my server.

I tried the Microsoft's OLE DB provider test connection OK but the next step errors with ORA-01017. invalid username/password.

Then I tried the Oracle's OLEDB Provider same thing, connection tested OK, next page this time error ORA-01005 null password given.. I did give it the same passwword as my sqlplus connection on the same server.

I have another server running SQL server 2000 SP4 and connecting to the same database oracle 9.2 db. and this works OK

any Ideas ????

Mustafa-383331 Newbie Points: 3 More actions · Answer 4

I experienced the same error message and was able to fix by enabling \ checking "Save Password" checkbox.

Hope this helps.