Questions

How do I get sysWOW64\odbcad32.exe to work on 64 bit machine?

+
0 Votes
Locked

How do I get sysWOW64\odbcad32.exe to work on 64 bit machine?

jdardard
I've been trying to access databases on my new 64 bit machine with Windows 7 Ultimate very unsuccessfully, of course. I understand that this feature is not possible with 64 bit machines. However, I did read a post recently regarding a question from a user with the same problem. The guy who answered the question said that this person should open the file "C\windows\sysWOW64\odbcad32.exe," which resolve his problem. I've tried that, and I can see all the User DSNs, System DSN, File DSN, Drivers, etc. on my ODBC Data Source Administrator -- none of which are there if I open the Data Source Administrator without exe file listed above. However, this whole thing disappears after closing the file, and I still cannot access any databases. Any suggestions? Thanks, JD.
  • +
    0 Votes
    andrew232006

    64bit windows maintains two completely separate collections of odbc connections.
    If you are using a 32bit program that needs access to an ODBC connection you would need to run "C\windows\sysWOW64\odbcad32.exe," to set up the ODBC.

    If you are running a 64bit program, use the default ODBC manager to add your ODBC connection.
    Depending on what you are trying to do, you may need to copy the settings from the 32bit odbc manager to create new connections in the default 64bit manager.

    +
    0 Votes
    jdardard

    Thanks, Andrew, for the quick reply. The information in your reply sounds very thorough. I think I should have made myself a bit more clear of what I was trying to do. I'm trying to develop web applications in which I want to include forms, of which the information entered would be entered into a microsoft database. I have no problem with forms. It's only when I try to test the applications and to view the database associated with the form that I get "ADOBC connection error 800a0e7a provider cannot be found. It may not be properly installed." All the research I've done on this subject has lead me to my original question which you've replied to. I understand that Windows 7 for 32 bit machines does not have this problem, but Windows 7 for 64 bit machines does, and I have Windows 7 and a 64 bit machine. Hope this help to clarify my original question. Thanks again. JD

    +
    0 Votes
    jdardard

    Sorry, but I couldn't open your last reply. I kept getting the message that the web page I was looking for was not available! Tried to open in several browsers -- same results. Please resend... Thanks, JD

    +
    0 Votes
    jdardard

    My apologies again. I've tried to use this link http://ct.techrepublic.com/clicks?t=1118568644-566ae6fc2348f4af8d940847cfb439f7-bf&brand=TECHREPUBLIC&s=5 several times, but again, I get the "The page you are looking for is not available." I know your replies are available, but with over 500 replies to look through, it's a long research project. I think I will resolve the issue by installing a 32 bit version of windows 7 on my system in addition to the current 64 bit version I currently hhave.

  • +
    0 Votes
    andrew232006

    64bit windows maintains two completely separate collections of odbc connections.
    If you are using a 32bit program that needs access to an ODBC connection you would need to run "C\windows\sysWOW64\odbcad32.exe," to set up the ODBC.

    If you are running a 64bit program, use the default ODBC manager to add your ODBC connection.
    Depending on what you are trying to do, you may need to copy the settings from the 32bit odbc manager to create new connections in the default 64bit manager.

    +
    0 Votes
    jdardard

    Thanks, Andrew, for the quick reply. The information in your reply sounds very thorough. I think I should have made myself a bit more clear of what I was trying to do. I'm trying to develop web applications in which I want to include forms, of which the information entered would be entered into a microsoft database. I have no problem with forms. It's only when I try to test the applications and to view the database associated with the form that I get "ADOBC connection error 800a0e7a provider cannot be found. It may not be properly installed." All the research I've done on this subject has lead me to my original question which you've replied to. I understand that Windows 7 for 32 bit machines does not have this problem, but Windows 7 for 64 bit machines does, and I have Windows 7 and a 64 bit machine. Hope this help to clarify my original question. Thanks again. JD

    +
    0 Votes
    jdardard

    Sorry, but I couldn't open your last reply. I kept getting the message that the web page I was looking for was not available! Tried to open in several browsers -- same results. Please resend... Thanks, JD

    +
    0 Votes
    jdardard

    My apologies again. I've tried to use this link http://ct.techrepublic.com/clicks?t=1118568644-566ae6fc2348f4af8d940847cfb439f7-bf&brand=TECHREPUBLIC&s=5 several times, but again, I get the "The page you are looking for is not available." I know your replies are available, but with over 500 replies to look through, it's a long research project. I think I will resolve the issue by installing a 32 bit version of windows 7 on my system in addition to the current 64 bit version I currently hhave.