OraFAQ Forum: Windows » ORA-01428 => ORA-01435

Home » Infrastructure » Windows » ORA-01428 => ORA-01435

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

ORA-01428 => ORA-01435 [message #184452]

Wed, 26 July 2006 10:29

marius
Messages: 4
Registered: July 2006

Junior Member

Hello,
I am trying to connect to an Oracle9i server on an Windows OS using OLEDB and ADO. Each time I get the "ORA-01428 user does not exist". I get this using the right user and password. If I connect using an invalid user or password the error changes and it announces me that the user/password is invalid and that there was no logon.
Any idea on what could be happening?

Thanks.

[Updated on: Sat, 05 August 2006 08:28] by Moderator

Report message to a moderator

Re: ORA-01428 => ORA-01435 [message #184498 is a reply to message #184452]

Wed, 26 July 2006 16:34

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you sure it is ORA-01428?

Quote:

ORA-01428 argument 'string' is out of range

Cause: An illegal value for a mathematical function argument was specified. For example

SELECT SQRT(-1) "Square Root" FROM DUAL;

Action: See the Oracle9i SQL Reference for valid input and ranges of the mathematical functions.

As of "user does not exist": did you specify not only username and password, but correct database? For example,

connect scott/tiger@ora_at_work

[Updated on: Sat, 05 August 2006 08:28] by Moderator

Report message to a moderator

Re: ORA-01428 [message #184597 is a reply to message #184452]

Thu, 27 July 2006 03:27

marius
Messages: 4
Registered: July 2006

Junior Member

Yes, it´s not this number. Actually it is ORA-01435.

I am connecting using:
Data source =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = comp01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

Report message to a moderator

Re: ORA-01428 [message #184667 is a reply to message #184597]

Thu, 27 July 2006 07:07

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

OK, this is ORA-01435:

Quote:

ORA-01435 user does not exist

Cause: This message is caused by any reference to a non-existent user. For example, it occurs if a SELECT, GRANT, or REVOKE statement specifies a username that does not exist. Only a GRANT CONNECT statement may specify a new username. All other GRANT and REVOKE statements must specify existing usernames. If specified in a SELECT statement, usernames must already exist.

Action: Specify only existing usernames in the SELECT, GRANT, or REVOKE statement or ask the database administrator to define the new username.

Are you sure (again) that TNSNAMES.ORA looks like you've said:

Data source =
(DESCRIPTION =

Is it really "Data source", or is it something else here? Should be something like ORCL, ORA10, etc., but not "Data source" (two blank separated words).

When you identify your database, username and a valid password, try to connect as I've already suggested.

Report message to a moderator

Re: ORA-01428 [message #184672 is a reply to message #184452]

Thu, 27 July 2006 07:32

marius
Messages: 4
Registered: July 2006

Junior Member

In the TNSNAMES.ORA is listed as ORCL but in the connection string it should be specified as Data source=. The fact is that with this connecting string it works between my computer and the one with the Oracle server, it works between my computer and another Oracle server but it does not work on the server that it must.

This is the code that I am using to connect:

adocnx= new ActiveXObject("ADODB.Connection");
adorec= new ActiveXObject("ADODB.Recordset");
adocnx.open ("Provider=OraOLEDB.Oracle;Data source="+bas+";user id="+usu+";password="+pwd);

where bas,usu,psware obtained from an external file which looks like this:

Provider=OraOLEDB.Oracle;
Data source=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = comp01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
;user id=marius;password=marius;

Edit: Can one of the administrators change the name of the topic into ORA-01435? Thank you.

Edit2: I am really stupid!!! The problem was that the name of the file should have been the same as the scheme that contains the tables. Thanks for the help Littlefoot.

[Updated on: Thu, 27 July 2006 11:25]

Report message to a moderator

Previous Topic:	Moving DB from Linux to Windows
Next Topic:	After instal Oracle 9i R2 my harddisk space is insufficient

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 11:29:02 CST 2024