G'day Mike, The link to the site for the ODBC driver is http://myob.com/servlet/Satellite?cid=1179964249445&pagename=MYOB%2FPage%2FC ontentPageWithNav&site=en_AU&c=Page (it is around 20MB). You can download a test drive version of MYOB Premier from http://myob.com/servlet/Satellite?cid=1111637498189&attrname=FreeTrials&page name=MYOB%2FSecureDownload%2FCustomSecureDownloadForm¶m=1111637498189&pr oductId=1111440830686&site=en_AU&c=SecureDownload (it is around 65MB) but I could instead email you a zipped version of the clearwtr.myo datafile which is only around 700kb. There is no restriction on the ODBC driver and the clearwtr file.
Thanks & regards Clive Williams > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB > Sent: Monday, 12 May 2008 21:17 > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: ODBC problems V8 connecting to MYOB continuing > > Clive, > > It will be tough to solve this mystery without having a myob sample > dataset > and the ODBC driver. Does the company offer a time limited animal for > testing > or trial? > > > ----- Original Message ----- > From: "Clive Williams" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Monday, May 12, 2008 3:02 AM > Subject: [RBASE-L] - ODBC problems V8 connecting to MYOB continuing > > > > G'day, > > > > > > > > I am, despite Mike Byerley's kind help, still unable to connect to a > MYOB > > datafile (only tried on Australian version). I have established a > System > > DSN for the MYOB sample file clearwtr.myo and can use that to extract > data > > to both Excel and Access 2007 with no difficulty - there are no > restrictions > > on the MYOB ODBC drivers and the clearwtr test file. Using RRBYW14 I > have > > gone to Utilities>Connect SQL Data Source, clicked on the Machine > Data > > Source tab and then on the appropriate system DSN. When I go to > > Utilities>Attach SQL Database Tables I am presented with the Attach > Table(s) > > dialog box. Selecting a table and then clicking Attach does nothing > - the > > dialog window remains open. I am running R:Base V8.0.17.30509 on a > Toshiba > > Tecra with 2GB of RAM and an Intel Centrino duo processor under > Windows > > Vista Business. It doesn't matter if I have UAC on or off. > > > > > > > > I tried Mike's suggestion on a DSN less connection and when I try > that using > > a test database with just 1 table defined using:- > > > > > > > > --ConnectCRWS > > > > --Test connection string for DSNless connection to clearwtr.myo > > > > --Last updated by Clive Williams 12 May 08 > > > > > > > > CLEAR VAR vConnect > > > > SET VAR vConnect TEXT = + > > > > 'SCONNECT '';DRIVER={MYOB_ODBC_AU7}; TYPE=MYOB; UID=Administrator' > > > > SET VAR vConnect = + > > > > (.vConnect + '; PWD; DATABASE=C:\AllWork\Premier11\Clearwtr.myo') > > > > SET VAR vConnect = + > > > > (.vConnect + '; HOST_EXE_PATH=C:\Premier11\MYOBP.exe; > > NETWORK_PROTOCOL=NONET') > > > > SET VAR vConnect = + > > > > (.vConnect + '; DRIVER_COMPLETION=DRIVER_NOPROMPT') > > > > SET VAR vConnect = + > > > > (.vConnect + '; SQL_LOGIN_TIMEOUT=30;') > > > > &vConnect > > > > RETURN > > > > > > > > Running this command file at the R> prompt results in the message:- > > > > -ERROR- Error message from server: [MYOB ODBC] Connection exception - > > Connection does not exist (2957) > > > > The commands are taken from Mike's advice and the MYOB ODBC > documentation. > > > > > > > > The MYOB file referred to is the sample one that is supplied with > MYOB and > > all tables are accessible via ODBC and not restricted as are non- > registered > > files. I also have my own MTOB file that is registered for ODBC and > can > > extract the same data to both Excel & Access. > > > > > > > > Can anyone suggest how I can establish a connection that enables me > to > > extract the same data I can easily extract via the M$ products. I > did note > > that when a table was extracted to Access the table name showed as > > MYOB_Customers although it showed as MYOB.Customers on the Attach > Tables > > screen. > > > > > > > > The project is for one of the largest freight companies in Australia > who are > > looking at the extraction of MYOB invoices from clients datafiles and > > importing the data with additional formatting into a SAP database. > Quite > > sensibly, they have a prohibition on Access within their organisation > (the > > only time I have used it is to see if I could do the data extraction > to that > > system), so extracting to Access then going from Access to R:Base is > not an > > option. > > > > > > > > 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 > > > > > > > > > > > > > > > __________ Information from ESET Smart Security, version of virus > signature database 3092 (20080512) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3092 (20080512) __________ The message was checked by ESET Smart Security. http://www.eset.com
