Clive, Here is a link to a text file I created showing a working example of a DSN-Less connection to an Access DB. I found only ONE example of an MYOB DSN-Less connection that I used to construct an example in the text file. Give it a Go and see if it helps any. If the Connection works, then use the rest of the Access example to SATTACH to your tables and so on.
www.byerley.net/clive.txt ----- Original Message ----- From: "Clive Williams" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Sunday, May 04, 2008 8:45 AM Subject: [RBASE-L] - Re: ODBC connection problems V8 > 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 > > >
