ODBC 64-bit and 32-bit drivers
1) There are two types of ODBC connections supported by the PxPlus ODBC workstation driver
a) A simple client connection whereby the ODBC driver runs on the workstation and directly accesses the files as either local files or mapped drives.
b) A server connection whereby the ODBC driver connects to a server on another machine which in turn accesses the files.
2) We supply workstation drivers in either 32 bit or 64 bit form.
The 32-bit driver can be installed and used on either a 32 bit or 64 bit Windows system.
The 64 bit driver can only be installed on a 64 bit Windows system.
3) The 32 bit workstation driver can only be used by a 32 bit application and the 64
bit workstation driver
can only be used by a 64 bit application.
NOTE: Microsoft still recommends that users install 32 bit Office
regardless of whether the Windows system is 32 or 64 bit.
See:
http://office.microsoft.com/en-us/products/office-2010-frequently-asked-questions-HA101674631.aspx#About_Office_2010_4
4) By default, the Windows ODBC configuration utility will ONLY recognize drivers of the same type as the Windows OS. That is the Windows ODBC
configuration utility on a 64 bit Windows system will only allow access to 64
bit workstation drivers. To configure 32 bit ODBC drivers on a 64 bit
Windows system you must use the ODBCAD32.exe program found in the windows SYSWOW directory.
NOTE: That to make this easier, when installing the
current PxPlus 32 bit driver on 64 bit systems, we automatically create a shortcut to the proper configuration utility for the user.
5) When connecting to a server ('b' in item 1 above), the type of workstation driver (32 or 64
bit) is immaterial to server just as the type
of server is immaterial to the workstation driver. All communication between the two is over the network using TCP/IP thus the type of client or
server does not matter. Simply put, a 64 bit workstation driver can connect to a 32
bit server and a 32 bit workstation driver could connect to a 64 bit
server (if one existed).
|