Home » RDBMS Server » Networking and Gateways » ORA-01741: illegal zero-length identifier for DBlink (10g)
ORA-01741: illegal zero-length identifier for DBlink [message #446339] Sun, 07 March 2010 22:51 Go to next message
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 Go to previous message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Aug 08 05:25:57 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.