At 06:29 PM 8/8/2010, Luc Delcoigne wrote:
I installed 64 bit rbase 9.0 on my 64 bit WIn 7 PC.
When checking ODBC no Rbase odbc is listed.
Had no problems on my 32 bit Win 7 laptop.
How can I solve this ?
Luc,
Here is your 3rd tip of the day!
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 (Correctly Configured and Installed R:BASE ODBC Drivers)
http://www.razzak.com/sampleapplications/ODBC/ODBCDataSourceAdministrator04.jpg
Make a note of all R:BASE and Oterro ODBC drivers, including the latest
versions and builds.
That's all there is to it!
Have fun running R:BASE eXtreme 9.0 on Win 7 Professional (64), Win Server
2003 R2 x64, and Win Server 2008 (64) operating systems!
Very Best R:egards,
Razzak.
