G'day Mike, Thank you for the example - I will try it and let you know how it goes.
Regards Clive Williams CRW Services 53 Gibson Street Silverdale NSW 2752 Mobile: 0418 657 833 A H: (02) 4774 0868 email: [EMAIL PROTECTED] MYOB Certified Consultant Ostendo Consulting Partner MYOB Accredited Trainer Cert IV Workplace Training & Assessment > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB > Sent: Monday, 5 May 2008 00:28 > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: ODBC connection problems V8 > > 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 > > > > > > > > > > > __________ NOD32 3072 (20080503) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.eset.com --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
