DM-DBM-0306 UDA driver error connecting to 'ALIAS_******'

Have you tried testing the connect of remote catalog db successful or not in sqlplus?

Hi Guys,

I have installed the data manager and when I try to open a catalog which was created on another machine, I'm getting the following error:

1. ERROR

DM-DBM-0306 UDA driver error connecting to 'ALIAS_*****'.

I'm trying to open an oracle catalog and I have Oracle client 9g and 11g installed.

Thanks,

Colin

Yes, I can connect successfully using sqlplus

Let me know if I understand right.What you do is:
1) Create a database using Oracle 11g server and restore DM catalog, suppose the database named "TEST", and the machine is "A"
2) Configure Oracle client 9g and listen to "TEST", testing in sqlplus connection is okay, and the machine is "B"
3) Start DM in "B", and open catalog in "TEST"

Yes, I can connect successfully using sqlplus

We have the developer tools built out on 1 machine - we can open the catalog using the data manager and we are having no issues - this machine has the Oracle 9g and 10g client installed.

The database on which the catalog is installed is Oracle 10g.

We have installed the dev tools on two other machines which have the Oracle 9g and 11g client installed.

We can connect and query the db containing the catalog using SQL Plus on both these machines.

When we attempt to open the catalog using the data manager we are getting the error.

Hi Jinpeng, I get a similar error connecting to DB2 DB from windows 7 workstation that is running datamanager

Error Details as follows --> "1. ERROR
DM-DBM-0306 UDA driver error connecting to 'ALIAS_06DA0B28'."

I am able to test connection to this DB in DB2 Configuration assistant as well as command center.

I am also getting the error:

1. ERROR
DM-DBM-0306 UDA driver error connecting to 'ALIAS_06BCA0C8'.

I created the database in DB2 on Windows 7 Pro, 64-bit. I tried using it as a new DM catalog but when I hit the Test button, I got the above error.

What's the workaround?

Thx to Kelvin Low for the resolution. My error was that I didn't provide the username and password. I don't recall needing to do that on Windows XP. Maybe Windows 7 has tighter security in this respect. I created the database on my W520 laptop and was running DM from it. I didn't created any access control on the database.

Summary: Be sure to provide a username and password for the database connection.