ODBC cannot set by command line

%3CLINGO-SUB%20id%3D%22lingo-sub-1516585%22%20slang%3D%22zh-CN%22%3EODBC%20cannot%20set%20by%20command%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516585%22%20slang%3D%22zh-CN%22%3EOracle%20x86%20is%20installed%20in%20a%20x64%20window%2010%20system%2C%20but%20cannot%20set%20as%20below.%20Error%20screen%20shots%20as%20attached%20.%20%3CBR%20%2F%3E%20Used%2032-bit%20and%2064-bit%20odbcconf.exe%20is%20also%20ys.%20%3CBR%20%2F%3E%20C%3A%20SysWOW64%3Fodbcconf.exe%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20ODBCCONF%20CONFIGSYSDSN%20%22Oracle%20in%20OraClient11g_home1%22%20%22DSN%3Fxxx%22%20SERVER-xxx%22%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20odbcconf.exe%20%2FA%20(CONFIGSYSSDSN%22%20%22Oracle%20in%20OraClient11g_home1%22%20%22DSN%3Fxxx%3B%20SERVER-xxx%22%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1516585%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EOdbc%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOracle%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518928%22%20slang%3D%22en-US%22%3ERe%3A%20ODBC%20cannot%20set%20by%20command%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518928%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725847%22%20target%3D%22_blank%22%3E%40Michaelyu%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20read%20the%20error%20message%20right%20it%20has%20some%20issues%20with%20the%20installation.%20Three%20possible%20reasons%20come%20to%20my%20mind.%26nbsp%3B%3CBR%20%2F%3E1st%3A%20The%20client%20is%20not%20installed%20correctly.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20reinstall%2Funistall%2FInstall%20new%3F%3C%2FP%3E%3CP%3E2nd%3A%20The%20registry%20key%20the%20process%20tries%20to%20read%20needs%20higher%20permissions.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Run%20as%20administrator%3F%3C%2FP%3E%3CP%3EAnd%20of%20course%20any%20typo%20in%20the%20path%20etc%20are%20also%20possible.%3C%2FP%3E%3CP%3EGood%20luck!%3C%2FP%3E%3CP%3ECheers%3CBR%20%2F%3ERolf%3CBR%20%2F%3E%3CBR%20%2F%3E%23MCT%20%23LearnWithRolf%20%23TheCloud42%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Oracle x86 is installed in a x64 window 10 system, but cannot set as below. Error screen shots as attached .
Used 32-bit and 64-bit odbcconf.exe are also failed.
C:\Windows\SysWOW64\odbcconf.exe

ODBCCONF CONFIGSYSDSN "Oracle in OraClient11g_home1" "DSN=xxx|SERVER=xxx"

odbcconf.exe /A {CONFIGSYSDSN "Oracle in OraClient11g_home1" "DSN=xxx;SERVER=xxx"}
1 Reply
Highlighted

Hello @Michaelyu

 

If I read the error message right it has some issues with the installation. Three possible reasons come to my mind. 
1st: The client is not installed correctly.

        reinstall/unistall/Install new?

2nd: The registry key the process tries to read needs higher permissions.

        Run as administrator?

And of course any typo in the path etc are also possible.

Good luck!

Cheers
Rolf

#MCT #LearnWithRolf #TheCloud42