At 06:41 PM 2/4/2009, TOM HART wrote:
I have a full license to Rbase 7.6, I just upgraded to a 64-bit computer, is that a problem?
Oh Tom .. if you would have provided all details, including the 64-bit operating system, in your first request, most likely, I would have told you the exact problem. However, the following explanation as well as step-by-step illustration should take care of your specific issue. In any case, here you go ... Typically, using the full installers, after a successful installation of R:BASE 7.6 for Windows, R:BASE Turbo V-8 for Windows, Oterro 4.0, or Oterro 8.0, you would expect the R:BASE or Oterro ODBC drives to be listed under the Drivers for ODBC Data Source Administrator panel. Well, by default, on Windows XP x64 bit Edition, Windows Vista (64), and Windows Server 2003 R2 x64 with SP2 machines, the installed ODBC Drivers list is empty. There are no drivers listed even Microsoft's own default drivers. Figure 01 http://www.razzak.com/fte/ODBC/ODBCDataSourceAdministrator_01.png The reason the installed drivers are not listed is the way Windows x64 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 you may use DSN-Less connection, if defined properly. Figure 02 (Default Properties for ODBC Data Source Administrator) http://www.razzak.com/fte/ODBC/ODBCDataSourceAdministrator_02.png Figure 03 (Modified Properties for ODBC Data Source Administrator) http://www.razzak.com/fte/ODBC/ODBCDataSourceAdministrator_03.png Figure 04 (Installed ODBC Drivers on Windows Vista Business 64) http://www.razzak.com/fte/ODBC/ODBCDataSourceAdministrator_04.png (R:BASE 7.5, R:BASE 7.6, R:BASE 8.0, and R:BASE eXtreme 9.0 (64) Figure 05 (Installed ODBC Drivers on Windows Vista Business 64) http://www.razzak.com/fte/ODBC/ODBCDataSourceAdministrator_05.png (Oterro 3.5, Oterro 4.0, Oterro 8.0, and Oterro 9.0 (64) Have fun working with R:BASE/Oterro ODBC drivers on Windows x64 operating systems! Very Best R:egards, Razzak.
