Solved

Any good manual/tutorial to create ODBC connection with odbcconf.exe under windows?

Posted on 2008-10-02
10
3,987 Views
Last Modified: 2013-12-18
Dear Experts:

    I need to write a batch file that can install ODBC connections (to Oracle database) on client's computer.

    After googling I noticed that a usual way needs to explicitly add records to Registry (using VB code, etc), and I don't want to do that. Fortunately I also found the name of odbcconf.exe from the following webpage:
http://www.myitforum.com/forums/m_138129/mpage_1/key_/tm.htm#138129
    Which gave me a hope for a much simpler way to do the job. However I couldn't find a good manual/tutorial/reference to teach me how to do this.

    Can you tell me where I can find a good tutorial? Or any better way?
    Thank you!

Sui
0
Comment
Question by:huangs3
  • 6
  • 4
10 Comments
 
LVL 9

Expert Comment

by:mgonullu
Comment Utility
0
 

Author Comment

by:huangs3
Comment Utility
Hi mgonullu:

    The accepted solution is not exactly what I am looking for, because it uses VBS code, and it directly changes registry.
    I am assuming odbcconf.exe can do the job and looking for the way to use it.
    Thank you!

Sui
0
 

Author Comment

by:huangs3
Comment Utility
I tested the following DOS command and it produced the oracle connection for me:
********************************************************************************************
odbcconf.exe /a {CONFIGDSN "Oracle ODBC Driver" "DSN=test1|Description=testdesp|SERVER=dbname|USER=username"}
*******************************************************************************************

Now I have another question: what command can I use to delete the ODBC connection?
0
 
LVL 9

Expert Comment

by:mgonullu
Comment Utility
wait please i will respond
0
 
LVL 9

Accepted Solution

by:
mgonullu earned 500 total points
Comment Utility
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:huangs3
Comment Utility
Hi mgonullu:

    I don't think it is, because it is for the software "dbdsn", and seems to me it is a UNIX/LINUX program. Any idea?
0
 
LVL 9

Expert Comment

by:mgonullu
Comment Utility
This is the only thing I found
0
 

Author Comment

by:huangs3
Comment Utility
Still thanks for your finding. The full manual of this software doesn't seem to be available then.
0
 

Author Comment

by:huangs3
Comment Utility
The manual you found is relevant even though not exactly what I want.
0
 

Author Closing Comment

by:huangs3
Comment Utility
You did a good job, but the solution doesn't seem exist, so still give out points.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
I have published numerous articles here at Experts Exchange that present programs/scripts written in a language called AutoHotkey. Each of those articles has a brief paragraph describing where to download the product and how to install it. I have al…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

763 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

12 Experts available now in Live!

Get 1:1 Help Now