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 --- 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. ================================================
