[cfaussie] MYOB ODBC Read Integration using Cold Fusion

2012-03-01 Thread raiola
Hi, I am trying to connect to the myob database using the myob odbc driver The drive is installed and I am able to read the myob database using MS excel without an issue However when I try and create the DataSource connection to the same odbc Myob Driver so that I can have CF read the

RE: [cfaussie] MYOB ODBC Read Integration using Cold Fusion

2012-03-01 Thread Steve Onnis
You need a specific MYOB license to be able to connect to it via ODBC From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Friday, 2 March 2012 1:00 PM To: cfaussie@googlegroups.com Subject: [cfaussie] MYOB ODBC Read Integration using Cold Fusion Hi, I am trying to connect

RE: [cfaussie] MYOB ODBC Read Integration using Cold Fusion

2012-03-01 Thread raiola
Hi Steve Yes I know about the developers license however the read only version without the write facility is free to use and its this read only one that I am currently able to read the data from the myob tables using excel connecting via the odbc connection I have created When I try and

Re: [cfaussie] MYOB ODBC Read Integration using Cold Fusion

2012-03-01 Thread Mike Kear
I had a job to do this a few years ago, and while I'm a bit hazy about how it ended up, I think what I needed to do was create an Access link database - all the tables linking to tables in the MYOB database using the driver provided by MYOB. Then you create a CF datasource on the Access database.