[RBG7-L] - RE: A Happy RBASE customer

[Gunnar Ekblad]

Deb My hero on the list for R:Base Access integration was Mike B. (Thank you Mike) In the beginning I had some issues. Most of mine where solved By SSQL and SET ANSI OFF (ACCESS allows a few funny things in it datadictionary or maybe they don’t have one)). Also to remember forget forgiving R:Base syntax like append use INSERT, don’t use compute Use SELECT and so on…. For SCONNECT you can define the ODBC bases in DBADMIN, but programmatically I like better the DSN-Less approach (There is FTE article on that one ) After SCONNECT you need SATTACH and when you do be specific on the primary key in the foreign DB Generally speaking I find it lot more easy to interface Access to R:Base, then R:Base to Access. To me that is a sign that RBTI does the best job! There are in my case I have still outstanding ISSUES one was discussed a while back with large dataset on a SQL server, I think that might bee an issue even for access. Good luck all I can say it is possible!     Gunnar Ekblad   -----Original Message----- From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of Deb Roepken Sent: den 25 maj 2005 16:43 To: RBG7-L Mailing List Subject: [RBG7-L] - A Happy RBASE customer   Hi-   I'm happy to say my customer is delighted with the product I designed for them and have asked me to look into connecting to an outside data source (Access), or perhaps a complete conversion may be involved.  I've purchased Oterro 3 and started with the readme text and I assume ( and I don't like to assume) I have to start with SConnect.  Who can I talk to about this?   Deb Roepken CMR, Inc. 631-587-1495