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 > >> > > >> > 53 Gibson Street > >> > > >> > Silverdale NSW 2752 > >> > > >> > > >> > > >> > Mobile: 0418 657 833 > >> > > >> > A H: (02) 4774 0868 > >> > > >> > email: [EMAIL PROTECTED] > >> > > >> > > >> > > >> > > >> > > >> > > >> > -- > >> > No virus found in this incoming message. > >> > Checked by AVG. > >> > Version: 7.5.524 / Virus Database: 269.23.8/1412 - Release Date: > >> 5/2/2008 > >> > 4:34 PM > >> > > >> > > >> > >> > >> > >> > >> __________ NOD32 3072 (20080503) Information __________ > >> > >> This message was checked by NOD32 antivirus system. > >> http://www.eset.com > > > > > > > > > > > __________ NOD32 3072 (20080503) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.eset.com
