title: Having Trouble with ODBC DSNs and 32 bit vs 64 bit
body: <p>I am writing an application to interface with a Progress DataBase in VB.net. My development machine is a 32bit Win 7 computer. I have a System DSN configured for the database that I need to use. Since it's on a 32 bit machine its a 32 bit DSN. </p>
  
  <p>App works great on my local computer, the problem arises when I try to take it to one of our 64 bit machines. Now the 64 bit machines seem to have the 32 bit driver installed on them (I opened <code>C:\Windows\SysWow64\odbcad32.exe</code> which, based on research, should show my all 32 bit System DSNs and all User DSNs) and a seemingly same DSN (named the same way and everything) exists in System DSNs. </p>
  
  <p>I tried compiling for <code>x86</code> instead of <code>AllCPUs</code>, but I still get errors. Some of the errors are below. </p>
  
  <p>Any suggestions on how to fix this so that it runs on both 64 and 32 bit machines? Is there a way to make double sure that the 64 bit machines are working on the 32 bit DSNs? </p>
  
  <p>My understanding of Error [IM014] is that the program is finding the DSN on the 64 bit machine, but cant use it, because it's a 32 bit DSN. </p>
  
  <p>Most of the errors for the second error are on <a href="http://technet.microsoft.com/en-us/library/aa937531%28v=sql.80%29.aspx" rel="nofollow">here</a> All the 08S01's are "Communication Link Failures", the IM006 is "Driver's SQLSetConnectOption failed" and apparently HY000 has about 20 different meanings. </p>
  
  <pre>
  DSN Connection String, Target CPU: AllCPUs, 32 Bit Machine : Runs Fine
  DSN Connection String, Target CPU: AllCPUs, 64 Bit Machine : Error [IM014]
  DSN Connection String, Target CPU: x86    , 32 Bit Machine : Runs Fine
  DSN Connection String, Target CPU: x86    , 64 Bit Machine : Error [HY000]
                                                                     [HYC00]
                                                                     [08S01]
                                                                     [08S01]
                                                                     [08S01]
                                                                     [IM006]
  'Yes all of those errors on the last one are from one connection attempt.
  
  </pre>