Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


Photo

64bit ODBC drivers

- - - - -

  • Please log in to reply
7 replies to this topic

#1
todarsey

todarsey

    Member

  • Member
  • PipPip
  • 109 posts
I have a problem with a WinXP x64 computer. We have a 32 bit program that uses ODBC drivers but they are not showing up in the ODBC program. It doesn't show in either the system32 or the SysWOW64 versions. I know that the program will run on a x64 machine because I have it running on an other x64 XP machine and on a x64 Win7.
Windows Server 08 R2 x64
AMD Athlon II X2 3.0GHz
8GB RAM
4.5TB storage
CentOS x64 Web Server (Virtual)
CentOS x86 Web Server (Virtual)
Windows Home Server (Virtual)


How to remove advertisement from MSFN

#2
chilifrei64

chilifrei64

    How do you like your Chili?

  • Member
  • PipPipPipPipPip
  • 995 posts
what drivers are you trying to use and have you installed them on your Windows XP x64 machine yet? (Oracle, Firebird, mysql..... )

#3
todarsey

todarsey

    Member

  • Member
  • PipPip
  • 109 posts
Just an Access Database driver and I have installed them.
Windows Server 08 R2 x64
AMD Athlon II X2 3.0GHz
8GB RAM
4.5TB storage
CentOS x64 Web Server (Virtual)
CentOS x86 Web Server (Virtual)
Windows Home Server (Virtual)

#4
hwilliams

hwilliams
  • Member
  • 1 posts
Hi

If your application is 32bit then the ODBC Driver required it 32bit also. You can check it the 32bit ODBC Driver has been installed by checked the 32bit Registry hive of your windows 64bit OS, as detailed at:

http://support.microsoft.com/kb/305097

It will be listed under:

HKEY_LOCAL_MACHINE\Software\WOW6432Node\ODBC\ODBCINST.INI

This is where all your 32bit ODBC Driver must be listed as "installed" for them to be picked up by the 32bit ODBC Administrator for DSN setup/configuration and then subsequent use by 32bit applications.

Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink

#5
todarsey

todarsey

    Member

  • Member
  • PipPip
  • 109 posts
OK, I opened the 32 bit regestry with this %systemroot%\syswow64\regedit and went to this hive HKEY_LOCAL_MACHINE\Software\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers. It says that all of the drivers are installed but they are not showing up in the ODBC.

Attached Files


Windows Server 08 R2 x64
AMD Athlon II X2 3.0GHz
8GB RAM
4.5TB storage
CentOS x64 Web Server (Virtual)
CentOS x86 Web Server (Virtual)
Windows Home Server (Virtual)

#6
cluberti

cluberti

    Gustatus similis pullus

  • Supervisor
  • 11,252 posts
  • OS:Windows 8.1 x64
  • Country: Country Flag
To view these, are you running the ODBC admin application directly from the .exe in the \Windows\SysWOW64 folder? I believe it's odbcad32.exe.
MCTS Windows Internals, MCITP Server 2008 EA, MCTS MDT/BDD, MCSE/MCSA Server 2003, Server 2012, Windows 8
--------------------
Please read the rules before posting!
Please consider donating to MSFN to keep it up and running!

#7
todarsey

todarsey

    Member

  • Member
  • PipPip
  • 109 posts
Yes.

It's almost like it is still looking at the 64bit ODBC registry entries.

Attached Files


Edited by todarsey, 01 February 2010 - 12:41 PM.

Windows Server 08 R2 x64
AMD Athlon II X2 3.0GHz
8GB RAM
4.5TB storage
CentOS x64 Web Server (Virtual)
CentOS x86 Web Server (Virtual)
Windows Home Server (Virtual)

#8
todarsey

todarsey

    Member

  • Member
  • PipPip
  • 109 posts
Would doing a system repair fix my problem?
Windows Server 08 R2 x64
AMD Athlon II X2 3.0GHz
8GB RAM
4.5TB storage
CentOS x64 Web Server (Virtual)
CentOS x86 Web Server (Virtual)
Windows Home Server (Virtual)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users



How to remove advertisement from MSFN