How do I use odbcconf.exe
Nicole Lenz
I am stuck on a problem and I just don't get a solution. It seems so simple:
I want to register an Access mdb as ODBC data source under windows NT.
Since I want to do that during an installation routine, I cannot do it with
the gui.
I thought odbcconf.exe does what I want, but I just don't know how to use
it. I tried following (in a MS DOS Shell)
C:\>odbcconf CONFIGDSN "Microsoft Access Driver (*.mdb)"
"DSN=TestQuelle|Description=|DBQ=D:\Eigene\test.mdb|Driver=C:\WinNT\system32
\odbcjt32.dll|FIL=MS Access|UID="
C:\>odbcconf CONFIGSYSDSN "Microsoft Access Driver (*.mdb)"
"DSN=TestQuelle|Description=|DBQ=D:\Eigene\test.mdb|Driver=C:\WinNT\system32
\odbcjt32.dll|FIL=MS Access|UID="
C:\>odbcconf CONFIGSYSDSN "Microsoft Access Driver (*.mdb)"
"DSN=TestQuelle\0Description=\0DBQ=D:\Eigene\test.mdb\0Driver=C:\WinNT\syste
m32\odbcjt32.dll\0FIL=MS Access\0UID="
C:\>odbcconf CONFIGSYSDSN "Microsoft Access Driver" "DSN=TestQuelle"
C:\>odbcconf CONFIGSYSDSN "Microsoft Access Driver (*.mdb)" "DSN=TestQuelle"
and so on. The only thing that happens is that this "Help"-Dialog pols up to
show me how to use the problem. Hey, I am a programmer, but I seem to stupid
to use that lousy help.
Can anybody help me? Or does anybody have another idea how I could automate
the ODBC registration under windows?
Is there a possibility using a dll with rundll32.exe?
Thank you for any hint!
...Nicole
ShockwaveRider
I too am trying to figure out how to use this command. I did a complete search of the msdn/technet/kb areas of ms and could only find references as to where odbcconf.exe it comes from.
anyway......looking at the odbcconf /h and your examples, it looks like you need something like this:
odbcconf /a {CONFIGDSN drivername DSN} or at least the examples on the odbcconf /h popup seem to imply that the "commands" are within the Braces {} and you need the /a to imply an action. I'm hoping somebody has some experience using this command with examples too. Perhaps this is an internal command not meant to be used by end users?
I assume that you and myself are both trying to programmatically create file/system dsns without going through the odbc administrator program in the control panel?
I was thinking I have used ADO with windows script host to create dsn's programmatically.........
If you find out anything please send me an email and I will do the same for you.
"Nicole Lenz" <nicol...@tecinno.de> wrote in message news:982pel$10oq$1...@ID-73957.news.dfncis.de...
ShockwaveRider
http://203.228.216.23/download/odbcc
Well I've used every search engine available plus searched dejanews(now googlenews heheh) and thats basically all I could find.