7 Replies Latest reply: Jan 15, 2013 11:43 PM by Kgronau-Oracle RSS

    Issue with "at sign" - @

    984667
      I have tried to create a databaselink to a SQL SERVER but I'm facing issues with the username.
      When I use the following command the dblink is created but I am unable to connect to the dblink:

      CREATE DATABASE LINK mydblink
      CONNECT TO *"thiagobarnabe@msn.com"* IDENTIFIED BY "password"
      USING 'tripoint';

      When I test the dblink I receive the errors *ORA-01017: invalid username/password; logon denied. [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user *'thiagobarnabe'*. {28000,NativeErr = 18456}* and ORA-02063.

      If I use the following command I do not receive any error, it works perfectly:

      CREATE DATABASE LINK mydblink
      CONNECT TO "ThiagoBarnabe" IDENTIFIED BY "password"
      USING 'tripoint';

      It is important to notice that in both cases I'm using username and password enclosed by double quotes (") and both usernames and passwords are correct and exists in my SQLServer. In addition, in the error message we can see that the unrecognized user is what precedes the "at sign". I read Oracle documentation, tried to find any solution but so far I didn't find anything able to help me.

      Is it possible to use users with at sign or not?
      I would apreciate your valuable comments.

      Edited by: user12833006 on 14/01/2013 04:33