In reviewing the BEST forum for MAS the senior members have the following comments DO NOT use the Read/Write ODBC driver from ProvideX with MAS. It WILL result in 100% data corruption 100% of the time. and To clarify a little more.. as Best intended the ODBC to be read only, there are some key bits of info missing from the data dictionary which are necessary to do writes through the ODBC.. This is why you get data corruption, and why you shouldn't attempt it....
So at first I was told the ODBC simply did not allow a write (read only) now I'm being told that it will corrupt the data if R:Base writes to their database. I think that I'm getting a line....... because they don't want this to happen. Does anyone know if R:Base would corrupt an ODBC compliant ProvideX database?
At 03:36 PM 8/29/2005, you wrote:
At 03:23 PM 8/29/2005, Scott Stanfield wrote:
I can view data in their vcustomer table but it gives me errors
when I try to change and address from within R:base.
Scott,
Technically, it means that you don't have the rights/privileges
to update/modify database using their native ODBC driver.
Check the access rights, etc., and then SCONNECT the system DSN
using the owner password.
Hope that helps!
Very Best R:egards,
Razzak.
