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