SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Link Oracle <-> SQLSerer without password

chrissy2Mar 13 2009 — edited Mar 16 2009

Hi all,

I want to create a database link on oracle db to SQL Server. The user has no password set in SQL Server database.
I'm using the following statement

CREATE DATABASE LINK "SQL.MY_DOMAIN.COM"
CONNECT TO "my_user" IDENTIFIED BY VALUES  ' '
USING 'dg4msql';

But I get error message:
SQL Error: ORA-02153: invalid VALUES password string
02153. 00000 - "invalid VALUES password string"
*Cause: An encoded password string does not follow the VALUES clause.
*Action: Place a proper encoded password string after the VALUES clause.

Isn't it possible to create a dblink without password? Or how can this be done?

Thanks
chrissy

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2009

Added on Mar 13 2009

6 comments

4,521 views