Razzak, Thank you for your timely and detailed instructions. However when I attempt to follow them I run into an issue. I don't have a SysWOW64 folder.
I'm running Microsoft Windows XP Professional Version 2002 Service Pack 3 It doesn't look like I'm running a 64 version operating system. Although this appears not to be an R:BASE issue, I do appreciate any assistance in getting Oterro 9 configured properly. Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 25 May 2010 00:46:40 -0400 Subject: [RBASE-L] - Tip of the Day: Configuring R:BASE ODBC and Oterro Drivers on64-bit OS Tuesday, May 25, 2010 Tip of the Day: Configuring R:BASE ODBC and Oterro Drivers on 64-bit OS Supported Versions: . R:BASE 7.6 for Windows . R:BASE Turbo V-8 for Windows . R:BASE eXtreme 9.0 (32) . R:BASE eXtreme 9.0 (64) . Oterro 4.0 . Oterro 8.0 . Oterro 9.0 (32) . Oterro 9.0 (64) If you are running any of the R:BASE products above on MS XP (64), Vista (64), Win 7 Professional (64), or Windows Server 2003/2008 (64), you may need to tweak the registry settings to recognize installed R:BASE and 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 all XP (64), Vista (64), Windows Server 2003 (64), and Windows Server 2008 R2 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/sampleapplications/ODBC/ODBCDataSourceAdministrator01.jpg 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/sampleapplications/ODBC/ODBCDataSourceAdministrator02.jpg Figure 03 (Modified Properties for ODBC Data Source Administrator) http://www.razzak.com/sampleapplications/ODBC/ODBCDataSourceAdministrator03.jpg Figure 04 (Installed ODBC Drivers on Server 2003 R2x64 SP2 machines) http://www.razzak.com/sampleapplications/ODBC/ODBCDataSourceAdministrator04.jpg Have fun running R:BASE (7.6, V-8, 9.0) and Oterro (4.0, 8.0, 9.0) on Windows XP (64), Vista (64), Win 7 Professional (64), Win Server 2003 R2 x64, and Win Server 2008 (64) operating systems! Very Best R:egards, Razzak.
