Just a little note.
\nI discovered that one may access the 32 bit ODBC drivers on a 64 bit platform via: C:\\Windows\\SysWOW64\\odbcad32.exe and the 64 bit ODBC drivers via: C:\\Windows\\System32\\odbcad32.exe<\/p>\n
This may be handy if one must access a 32 bit application (like Access 2007) via ODBC in a 64 bit environment. The standard ODBC application doesn’t allow you to directly access the 32 bit ODBC connections on a 64 bit platform. It is bit awkward and one could circumvent this issue via a direct call to the 32 ODBC driver environment.<\/p>\n
One should always use the appropriate version of the ODBC Administrator tool. If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\\SysWOW64\\odbcad32.exe. The 64 bit ODBC drivers can be accessed directly using C:\\Windows\\System32\\odbcad32.exe. To indicate the type of DSN, you can add “_32” to the 32-bit user DSNs and “_64” to the 64-bit user DSNs.<\/p>\n
The 64-bit ODBC Administrator tool can also be invoked from Control Panel to manage user DSNs and system DSNs that are used by 64-bit processes. On a 64-bit operating system, the 32-bit ODBC Administrator tool is used for Windows on Windows 64 (WOW64) processes. You must directly invoke the 32-bit ODBC Administrator tool from the SysWoW64 folder. You can use the 32-bit ODBC Administrator tool to manage user DSNs and system DSNs that are used by WOW64 processes.<\/p>\n
On a 32 bit system, the 64-bit drivers cannot be installed (of course). The 32 bit ODBC driver are the only drivers that can be found; they can be accessed via the Control Panel.<\/p>\n
So, what do we have?
\nIn a scheme:<\/p>\n
| <\/td>\n | 64-bit Windows<\/td>\n | 32-bit Windows<\/td>\n<\/tr>\n |
| 64-bit Administrator<\/td>\n | C:\\Windows\\odbcad32.exe \nor \nStart -> Control Panels -> Data Sources (ODBC)<\/td>\n | N.A.<\/td>\n<\/tr>\n |
| 32-bit Administrator<\/td>\n | C:\\Windows\\SysWoW64\\odbcad32.exe<\/td>\n | C:\\Windows\\odbcad32.exe \nor \nStart -> Control Panels -> Data Sources (ODBC)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \n","protected":false},"excerpt":{"rendered":" Just a little note. I discovered that one may access the 32 bit ODBC drivers on a 64 bit platform via: C:\\Windows\\SysWOW64\\odbcad32.exe and the 64 bit ODBC drivers via: C:\\Windows\\System32\\odbcad32.exe This may be handy if one must access a 32 bit application (like Access 2007) via ODBC in a 64 bit environment. The standard ODBC […]<\/p>\n","protected":false},"author":1,"featured_media":756,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-694","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-nice-to-know"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=694"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/694\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=694"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} |