Clive, Look up the SATTACH syntax. You may need to us the "alias" options of that command. Remember if the MYOB naming conventions so not meet RBase standards you can sorround the MYOB name with the IDQUOTES value and assign a valid RBase name for tables and columns using the alias options.
Jim Bentley --- Clive Williams <[EMAIL PROTECTED]> wrote: > G'day Mike, > > Thanks for the reply. I have no idea what MYOB is written in > but it is > certainly not Access - speaking to the design people at MYOB I > get the > distinct impression that they would love to change the engine > to something > much more modern as well as completely redesigning the > product. > > > Regards > > Clive Williams > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of MikeB > > Sent: Sunday, 4 May 2008 21:50 > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Re: ODBC connection problems V8 > > > > Try DSN-Less Connection.. MYOB is an Access DB right? > > > > > > > > > > > > ----- Original Message ----- > > From: "Clive Williams" <[EMAIL PROTECTED]> > > To: "RBASE-L Mailing List" <[email protected]> > > Sent: Sunday, May 04, 2008 12:40 AM > > Subject: [RBASE-L] - Re: ODBC connection problems V8 > > > > > > > G'day Bob, > > > > > > Thanks for your reply. I probably did not explain myself > properly - > > I was > > > giving details of the installed V8 ODBC driver but am > trying to > > connect to > > > the MYOB data source the way you have given. Under > Utilities>Connect > > to a > > > Data Source I can connect and, after doing that, I go to > the > > Disconnect > > > option it shows that the data source is connected. The > problem I am > > having > > > is that when trying to attach a table from the data source > the table > > names > > > all appear with "MYOB." as the first part of the table > name - e.g. > > the > > > Customers table shows as MYOB.Customers - in Excel it only > shows as > > > Customers and the data dictionary only lists the table > name as > > Customers. > > > This appears to be where I am having the problems as I > cannot get the > > tables > > > to attach to the V8 database. > > > > > > > > > Regards > > > > > > Clive Williams > > > > > >> -----Original Message----- > > >> From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Bob > > >> Thompson > > >> Sent: Sunday, 4 May 2008 13:41 > > >> To: RBASE-L Mailing List > > >> Subject: [RBASE-L] - Re: ODBC connection problems V8 > > >> > > >> Clive, > > >> You would not use the V8 ODBC driver to connect to > another > > database. > > >> You > > >> use the other database's ODBC driver. For instance, you > have stated > > >> that > > >> you > > >> were successful in connecting to the MYOB file with > Excel. If that > > >> worked, > > >> you should be able to connect to the MYOB with V8. Go > to > > Utilities, > > >> Connect > > >> to a Data Source, select the Machine Data Source tab and > you should > > >> see the > > >> MYOB ODBC driver listed. It would be the same on you > used with > > Excel. > > >> So unless I misunderstand your email, it should work > fine. > > >> > > >> However.... > > >> If you are trying to connect to a V8 database from > MYOB, then you > > >> would > > >> need Oterro. The native ODBC drivers that come with 7.X > are only > > for > > >> Rbase to Rbase connections. (I am assuming that V8 is > the same) > > One > > >> must get Oterro if they are wanting to connect from a > non-Rbase > > program > > >> to a Rbase database. > > >> > > >> -Bob > > >> > > >> > > >> > > >> > > >> > > >> ----- Original Message ----- > > >> From: "Clive Williams" <[EMAIL PROTECTED]> > > >> To: "RBASE-L Mailing List" <[email protected]> > > >> Sent: Saturday, May 03, 2008 9:36 PM > > >> Subject: [RBASE-L] - ODBC connection problems V8 > > >> > > >> > > >> > G'day all, > > >> > > > >> > > > >> > > > >> > Using V8 database version 8.0.17.30502 and the V8 ODBC > driver > > >> 8.0.17.30428 > > >> > I > > >> > am trying to connect to a MYOB data source via a System > DSN with > > no > > >> > success. > > >> > I am using a Toshiba laptop that has an Intel Centrino > Duo > > processor > > >> with > > >> > 2GB of memory running Vista Business. I can connect to > the same > > data > > >> > source > > >> > in Excel 2007 via MS Query with no problems. > > >> > > > >> > > > >> > > > >> > Using either the latest RRBYW14 or a database with no > data and > > only > > >> one > > >> > table defined I have the same lack of result. > Utilities>Connect > > SQL > > >> Data > > >> > Source... allows me to select the data source under the > Machine > > Data > > >> > Source > > >> > tab. When I then try to select tables via > Utilities>Attach SQL > > >> Database > > >> > Tables I get the list of tables but all tables show > "MYOB." before > > >> the > > >> > table > > >> > name, unlike in Excel where just the table name, as > listed in the > > >> MYOB > > >> > data > > >> > dictionary, is shown. Choosing a table and clicking > Attach does > > >> nothing - > > >> > what am I doing wrong? > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > Regards > > >> > > > >> > > > >> > > > >> > Clive Williams > > >> > > > >> > > > >> > > > >> > CRW Services > > >> > > === message truncated === Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
