Solved

how to remove odbc definition of db2 on windows server 2003

Posted on 2010-09-16
5
1,705 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:iamari
5 Comments
 

Expert Comment

by:Stefan Tarras-Wahlberg
ID: 33696655
Just run   odbcad32.exe   and add/edit/remove the ODBC datasources there.
Or do you mean an alias for the db2 servername?
0
 
LVL 13

Expert Comment

by:rhinoceros
ID: 33698403
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
 
LVL 2

Author Comment

by:iamari
ID: 33701358
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
 
LVL 13

Expert Comment

by:rhinoceros
ID: 33730924
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
 
LVL 2

Accepted Solution

by:
pjaguilar earned 200 total points
ID: 34309711
Go to Programs, IBM DB2, Command Line Tools, Command Line Processor, and enter the command

UNCATALOG DB <alias>

It's done.

0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Power setting GPO not working 6 56
RDWeb 3 50
Windows 7 Updates 11 76
Domain and Forest functional levels 11 64
I have never ceased to be amazed how many problems you can encounter on a fresh install of a Windows operating system.  This is certainly case in point& Unable to complete ANY MSI installation.  This means Windows Updates are failing and I can't …
This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now