Razz, I followed what you outlined and tested it on your sample and it works fine, I browsed and did some updates on the sattached table tcontacts, it worked. Took your rmd file and modified it for my parameters and still have problems, I can update from the sconnected database but not to it, nor can I even browse the 2 tables sattached. Get following messages: I/O problem- check for a full disk(it is not even close to full) then get message: Cursor is not positioned on a valid row. I have to kill the program to exit. I checked both databases- no errors. These are both reloads. Tom
________________________________ From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, February 4, 2009 8:32:59 PM Subject: [RBASE-L] - Re: SConnect database question 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.
