The specified DSN contains an architecture mismatch between the Driver and Application. JAVA

None of these did it for me. I did find the answer on MSDN. There were hints to it though. The architecture in the error is referring to 32 vs 64 bits. My solution was to find out which my app is running under (Access) which 2010 is 32b. I found this by looking in the Process tab of Task Manager where all 32b processes have * 32 the end of their names. As was said, the control panel will launch the 64 bit version of ODBC from here

c:\windows\system32\odbcad32.exe

and the 32 bit version is here:

c:\windows\sysWOW64\odbcad32.exe (easiest to copy and paste into run dialog)

So I set up DSNs with names ending in 32 and 64 in each of the corresponding ODBC control panels (AKA Administrator) that pointed to the same thing. Then, I picked/pick the correct one based on whether the app using it is 32b or 64b.

Related Posts:

  1. What is an instance variable in Java?
  2. super() in Java
  3. What’s the syntax for mod in java
  4. What does the Java assert keyword do, and when should it be used?
  5. How do I make a delay in Java?
  6. Casting variables in Java
  7. max value of integer
  8. How can I prevent java.lang.NumberFormatException: For input string: “N/A”?
  9. What is the difference between == and equals() in Java?
  10. What does “?” mean in Java?
  11. Java – No enclosing instance of type Foo is accessible
  12. Why I am getting java.lang.AbstractMethodError errors?
  13. fix java.net.SocketTimeoutException: Read timed out
  14. what is the difference between OLE DB and ODBC data sources?
  15. How to override equals method in Java
  16. java.text.ParseException: Unparseable date
  17. Java – String cannot be converted to int
  18. java.io.IOException: Broken pipe
  19. java.util.NoSuchElementException: No line found
  20. Even though JRE 8 is installed on my MAC -” No Java Runtime present,requesting to install ” gets displayed in terminal
  21. Reason for the exception java.lang.VerifyError: Bad type on operand stack
  22. Downcasting in Java
  23. Java “params” in method signature?
  24. How do I time a method’s execution in Java?
  25. repaint() Method in Java
  26. java.sql.SQLException: No database selected – why?
  27. Exception in thread “main” java.lang.reflect.InvocationTargetException
  28. How to set String’s font size, style in Java using the Font class?
  29. How to use the command update-alternatives –config java
  30. java array error “array required but int found”
  31. this: Cannot use this in static context
  32. What’s the difference between SoftReference and WeakReference in Java?
  33. How to draw lines in Java
  34. NoClassDefFoundError in Java: com/google/common/base/Function
  35. In Java, what is a shallow copy?
  36. Good way to encapsulate Integer.parseInt()
  37. Eclipse IDE – Error: Build path specifies execution environment Java SE 1.7
  38. Java: Not a statement
  39. ArrayList of int array in java
  40. How to get the filename without the extension in Java?
  41. How can I upgrade to Java 1.8 on an Amazon Linux Server?
  42. Substring in excel
  43. What is the difference between POST and PUT in HTTP?
  44. How does npm start work? What all processes are happening in the background?
  45. What is the := operator?
  46. What is Xpenology? Is it Linux related thing?
  47. Is there a way to get Bing’s photo of the day?
  48. How to get current timestamp in string format in Java? “yyyy.MM.dd.HH.mm.ss”
  49. Chrome: Uncaught SyntaxError: Unexpected end of input
  50. Muting a Discord user on my Server
  51. What is null in Java?
  52. MacOS Catalina(v 10.15.3): Error: “chromedriver” cannot be opened because the developer cannot be verified. Unable to launch the chrome browser
  53. Can I catch multiple Java exceptions in the same catch clause?
  54. How to get the current date/time in Java
  55. What is the use of printStackTrace() method in Java?
  56. How do I limit the number of decimals printed for a double?
  57. Please initialize the log4j system properly warning
  58. Convert array of strings into a string in Java
  59. What is Serialization?
  60. Manually create a pyspark dataframe
  61. SSL and cert keystore
  62. Choosing the best concurrency list in Java
  63. Android Completely transparent Status Bar?
  64. Why nextLine() and not nextString() ?
  65. Very Basic Java
  66. How to sign-extend a number in Verilog
  67. How to draw a checkmark / tick using CSS?
  68. Why does the number of rows change during AIC in R? How to ensure that this doesn’t happen?
  69. Converting A String To Hexadecimal In Java
  70. javax.xml.bind.UnmarshalException: unexpected element (uri:””, local:”Group”)
  71. Enqueue, Dequeue and ViewQueue in Java
  72. org.xml.sax.SAXParseException: Content is not allowed in prolog
  73. Running Command Line in Java
  74. Working Soap client example
  75. Simple Dropdown menu in Java
  76. Can we use & in url?
  77. tic tac toe java user vs computer
  78. Java Wait for thread to finish
  79. How to convert an Instant to a date format?
  80. How to sleep for five seconds in a batch file/cmd
  81. equivalent to push() or pop() for arrays?
  82. JaxbRepresentation gives error “doesnt contain ObjectFactory.class or jaxb.index”
  83. Converting a 2-3-4 tree into a red black tree
  84. Generic stack implementation
  85. Java generating non-repeating random numbers
  86. WAMP Server – local server – 1 of 2 services running
  87. java eclipse red exclamation mark
  88. What is Angular Routing?
  89. Java FileOutputStream Create File if not exists
  90. How to find the Target *.exe file of *.appref-ms
  91. How to specify the default error page in web.xml?
  92. Exception is never thrown in body of corresponding try statement
  93. Could not transfer artifact org.apache.maven.plugins:maven-surefire-plugin:pom:2.7.1 from/to central (http://repo1.maven.org/maven2)
  94. Is there an Amazon.com API to retrieve product reviews?
  95. How to reference a function from a class in a different file which is also namespaced?
  96. Follow author on muti-user WordPress site
  97. Any benefit or detriment from removing a pagefile on an 8 GB RAM machine?
  98. How do I view the details of a digital certificate .cer file?
  99. How do you validate fstab without rebooting?
  100. DNS – NSLOOKUP what is the meaning of the non-authoritative answer?

Leave a Comment