?
Solved

How to administer ODBC using dos prompt

Posted on 1997-08-29
3
Medium Priority
?
1,907 Views
Last Modified: 2008-03-03
Is there any hidden option for odbcad32.exe?
What I need to do is to administer data source (add, delete,
admend) using dos prompt command. So how can I do it?
0
Comment
Question by:cwchaw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Accepted Solution

by:
Srw earned 40 total points
ID: 1025245
If you're looking for a DOS command that gives the functionality of the ODBC administrator, I don't think there is one, but...
The answers you're looking for reside in the ODBC.ini and ODBCINST.ini.

The ODBCINST.ini file contains information about your drivers.
The ODBC.ini file contains information about each data source.

You can modify the ODBC.ini file by hand to create new data sources, but be very careful and save a backup copy since it's easy to completely screw-up your odbc this way. I also suggest using the administrator the first time, so you get all the correct parameters for each driver.  (Each could be different)

Unfortunately, with Win95, it's possible that these files exist as registry entries in the HKEY_LOCAL_MACHINE/SOFTWARE/ODBC area.

The odbc administrator calls each driver's DLL to run it's own setup, so it doesn't need to know the formats in the INI files.  But, these DLLs require the GUI portion of windows since they use dialog boxes.

Hope this helps!
0
 

Expert Comment

by:rpabst
ID: 1025246
I do not totally agree with srw's answer so i'd like to comment.1. All ODBC entries (in Win95, WinNT) ARE in the registry   (not possibly) so changing ODBC.INI is useless unless you're   still working with windows 3.x2. There are utilities that can create a new ODBC datasource   (restricted to the MDB and SQLServer drivers, as far as     i know.) and delete a source. They are delivered with   Internet Information Server 3.0 and run only on Win32   platforms. These are command-line utilities that can be   called from BAT/CMD files and can be found in the   /inetpub/scripts directory.Good luck.
0
 

Author Comment

by:cwchaw
ID: 1025247
Dear Srw & rpabst,

Thanks for your comment, both of you are right in certain way. So I am working on how to do the setting on the registry file.


0

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

777 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