It worked! HAPPY DAYS!!! The ODBC drives magically appeared! I am truly amazed and thankful!!!
Mike
PS: Is there some trick to uninstalling Rbase 7.6 on Windows 2003 64 bit in case I ever need to do so?
-------------- Original message from "A. Razzak Memon" <[email protected]>: --------------
> 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.
>
>
