OraFAQ Forum: Networking and Gateways » ORA-01741: illegal zero-length identifier for DBlink

Home » RDBMS Server » Networking and Gateways » ORA-01741: illegal zero-length identifier for DBlink (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01741: illegal zero-length identifier for DBlink [message #446339]

Sun, 07 March 2010 22:51

summoner
Messages: 44
Registered: March 2009

Member

Dear all,

I tried to create a DB link that connects to SQL server
Right now I could connect the SQL server and able to test the connection by tnsping.

When I tried to create a dblink, it failed and the message shows

CREATE PUBLIC DATABASE LINK "ODBC"  CONNECT TO "user" IDENTIFIED BY ""  using 'hsodbc'    

ORA-01741: illegal zero-length identifier

The problem is that our sql server does not have any password while identified by is a required field. Could anyone tell me how to solve it?

Thanks

Report message to a moderator

Re: ORA-01741: illegal zero-length identifier for DBlink [message #446345 is a reply to message #446339]

Sun, 07 March 2010 23:21

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Either give it a password or create a new user with a password for this database link.

Regards
Michel

Report message to a moderator

Previous Topic:	how to set orale Gateways 11g for mssql
Next Topic:	TNS Adopter Protocol error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 23 17:36:16 CDT 2026