Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4523
  • Last Modified:

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

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
huangs3
Asked:
huangs3
  • 6
  • 4
1 Solution
 
mgonulluCommented:
0
 
huangs3Author Commented:
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
 
huangs3Author Commented:
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mgonulluCommented:
wait please i will respond
0
 
mgonulluCommented:
0
 
huangs3Author Commented:
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
 
mgonulluCommented:
This is the only thing I found
0
 
huangs3Author Commented:
Still thanks for your finding. The full manual of this software doesn't seem to be available then.
0
 
huangs3Author Commented:
The manual you found is relevant even though not exactly what I want.
0
 
huangs3Author Commented:
You did a good job, but the solution doesn't seem exist, so still give out points.
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now