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
huangs3Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mgonulluConnect With a Mentor Commented:
0
 
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
mgonulluCommented:
wait please i will respond
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
All Courses

From novice to tech pro — start learning today.