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
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: 68624
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
Previous Topic: how to set orale Gateways 11g for mssql
Next Topic: TNS Adopter Protocol error
Goto Forum:
  


Current Time: Thu Mar 28 05:11:42 CDT 2024