|Huub de Hesselle
Joined: 30 Oct 2009
|Posted: Fri Mar 12, 2010 10:31 am Post subject: [64bit Windows] ODBC connection not visible
|tags: ODBC, context, connection, visibile, windows, 64 bit
64 bit Operatingsystems have two ODBC contexts, you need to make sure the right one is used to create ODBC connections.
MagnaView up to 4.2 is a 32 bit application, so any ODBC connection created needs to be created/visible in the 32 bit ODBC context.
The default ODBC interface found in 64 bit windows is the 64 bit ODBC context. To open the 32 bit context, do the following:
1. Open your system drive (most likely c:\)
2. Browse to the \windows\syswow64\ folder
(windows could be WINNT if your machine is upgraded from windows 2000 or earlier)
3. open odbcad32.exe
When in doubt about the context, try creating an ODBC connection to an Access database. At this point, there are no64 bit Access ODBC drivers. The lack of an Access driver indicates the 64 bit context.