how to remove odbc definition of db2 on windows server 2003

i'm trying to define a new odbc connection using the db2 driver on a windows 2003 server. however, looks like the alias i want to use was previously used with a different server name and i'm not able to reuse or remove it

how do i delete this obsolete alias? i've looked in the db2cli.ini file but it doesn't contain this info. searched the registry too and couldn't find it.
LVL 2
iamariAsked:
Who is Participating?
 
pjaguilarCommented:
Go to Programs, IBM DB2, Command Line Tools, Command Line Processor, and enter the command

UNCATALOG DB <alias>

It's done.

0
 
Stefan Tarras-WahlbergCommented:
Just run   odbcad32.exe   and add/edit/remove the ODBC datasources there.
Or do you mean an alias for the db2 servername?
0
 
rhinocerosCommented:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI for system DSN's
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI for user DSN's

Delete the key that you want,  and then reboot the computer
0
 
iamariAuthor Commented:
odbcad32.exe simply opens the odbc applet, which i was using. you can delete the datasource there, but not the database alias associated with the wrong server

the odbc.ini registry key doesn't contain any alias info either, it only has the datasource name and the driver
0
 
rhinocerosCommented:
You cannot find your DSN key name under ODBC.ini ???

Check under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.ini. There's a key for each DSN which contains the config values. Just delete the key. Also, there will be a single value corresponding to each DSN under the 'ODBC Data Sources' key. Delete that as well.

HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI for user DSN's

*** Backup first before you change the registry

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.