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