Author Topic: Error [Oracle][ODBC][Ora]ORA-01005: null password given; - not able to login  (Read 389 times)

lmachnik

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Hi

We have interesting issue:

We have EA client on PC and Pro Cloud Server configured. We use Oracle 32 bit client on the server.
ODBC source works fine on ProCloud server (we can test and connect to DB) and Database Managera and ports configuration looks OK but each time we want to connect to server from client we get:

    Pro Cloud Server: Unable to connect to database

and below errors in server log:

 2022-05-19 10:36:43 [TRACE]:   Thread 28  ATTEMPT acquire connection to msdasql.1:earepo@dblog
 2022-05-19 10:36:43 [TRACE]:   Thread 28  ATTEMPT Opening a new database connection to msdasql.1:earepo@dblog (Provider=MSDASQL.1;Persist Security Info=False;User ID=earepo;Data Source=dblog)
 2022-05-19 10:36:43 [WARNING]: Failed to open database connection to Provider=MSDASQL.1;Persist Security Info=False;User ID=earepo;Data Source=dblog.
 2022-05-19 10:36:43 [WARNING]: Microsoft OLE DB Provider for ODBC Drivers [-2147217843]
 2022-05-19 10:36:43 [WARNING]: [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied
 2022-05-19 10:36:43 [WARNING]: Thread 28  FAIL unable to acquire connection.

Any ideas?
« Last Edit: May 20, 2022, 09:47:10 pm by lmachnik »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11819
  • Karma: +458/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Do not, under any circumstance, use Oracle as backend for EA.
It doesn't perform and will only give you headaches.

You'll thank me later

Geert

lmachnik

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile

lmachnik

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Any other ideas?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11819
  • Karma: +458/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Any other ideas?

Why other ideas? I'm serious, stop what you are doing, setup a different database (SQL Server, MySQL, ...) anything as long as it's not Oracle.
You are wasting your time and setting yourself (and your users) up for a lot of pain.

Search the forum for "Oracle" if you don't believe me.
I've been in your shoes, and still have the (mental) scars to remind me

Geert