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