At 08:50 PM 10/24/2009, Michael J. Sinclair wrote:
I installed Rbase 7.6 for Windows on a Windows 2003 64 bit server.
It seems to have installed ok, it even took the latest updates.
But, I don't see any Rbase ODBC drivers. I thought I might just
try to reinstall the program, but clicking on the Rbase 7.6 icon
under Remove Programs in the control panel does not do anything..
.it just blinks. I also can't reinstall using the Full Installer
because it says I have to uninstall any newer versions before I
can install using the Full Installer.
I am not having any of these problems when I install Rbase 7.6 on
a Windows 2003 32 bit server.
What am I doing wrong?
Is there a way to add the ODBC driver after I have already installed
the product??
Here is your tip of the day of configuring ODBC drivers on 64-bit OS.
If you are running R:BASE/Oterro on Windows Server 2008 (64), you
may need to tweak the registry settings to recognize R:BASE/Oterro
ODBC settings and installed drivers.
Typically, using the full installer, after a successful installation
of R:BASE/Oterro, you would expect the R:BASE/Oterro ODBC drives to
be listed under the Drivers for ODBC Data Source Administrator panel.
Well, by default, on Windows XP 64, Vista 64 and Windows Server 2008
x 64 with Service Pack 2 machines, the installed ODBC Drivers list is
empty. There are no drivers listed even for Microsoft's own default
drivers (can you believe that?).
Figure 01: http://www.razzak.com/fte/ODBC/ODBCDataSourceAdmin_01.png
The reason the installed drivers are not listed is the way Windowsx64
editions operate with the ODBC drivers. On Windows x64 editions, all
ODBC drivers are installed in the "%SystemRoot%\SysWOW64" folder.
However, the default ODBC Data Source Administrator that is available
through the Administrative Tools or Control Panel in Windows x64
Editions is located in the "%SystemRoot%\system32" folder, and only
searches this folder for ODBC drivers.
To fix this behavior on Windows x64 editions, you should update the
target information for shortcut properties of the ODBC Data Source
Administrator tool to reflect "%SystemRoot%\SysWOW64\odbcad32.exe".
This will correctly locate and list all installed ODBC drivers as
well as enable you to create a System DSN or should be recognized
when using the DSN-Less connection.
Figure 02 (Default Properties for ODBC Data Source Administrator)
http://www.razzak.com/fte/ODBC/ODBCDataSourceAdmin_02.png
Figure 03 (Modified Properties for ODBC Data Source Administrator)
http://www.razzak.com/fte/ODBC/ODBCDataSourceAdmin_03.png
Figure 04 (Installed ODBC Drivers on Server 2008 R2x64 SP2)
http://www.razzak.com/fte/ODBC/ODBCDataSourceAdmin_04a.png
http://www.razzak.com/fte/ODBC/ODBCDataSourceAdmin_04b.png
Have fun configuring R:BASE/Oterro on Windows XP 64, Vista 64 and
Windows Server 2003/2008 R2 x64 operating systems!
Very Best R:egards,
Razzak.
