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.
Once I had it going, it was reliable. It wasn't under a lot of stress - the job was to update my online SQLServer database with updated customer and orders information from the MYOB system once each night. It never had to handle multiple connections or anything like that. How it might work under any kind of stress I'm not able to say. I never managed to make CD WRITE to the MYOB database though which was the second half of the job. Neither MYOB nor Adobe nor anyone else was able to make that happen, despite many promises and claims. So it's good that you dont need to do that this time. If you do, expect to spend a fair amount of time frigging about trying to make it all work. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Mar 2, 2012 at 2:04 PM, <rai...@ozemail.com.au> wrote: > 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 make the same odbc connection in cfadministrator it > generates the error**** > > ** ** > > ** ** > > Connection verification failed for data source: myob > java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC > Socket]internal error: Data source name not found and no default driver > specified > The root cause was that: java.sql.SQLException: [Macromedia][SequeLink > JDBC Driver][ODBC Socket]internal error: Data source name not found and no > default driver specified**** > > ** ** > > ** ** > > ** ** > > ** ** > > Regards > > Claude Raiola (B.Econ Acc; B.Hot. Mngt) > Samaris Software > Email: i...@samaris.net <i...@trackingcentral.om.au> > Website: www.SAMARIS.net <http://www.samaris.net/> > Mobile: 0414 228 948**** > > ** ** > > *From:* cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] *On > Behalf Of *Steve Onnis > *Sent:* Friday, 2 March 2012 12:15 PM > *To:* cfaussie@googlegroups.com > *Subject:* RE: [cfaussie] MYOB ODBC Read Integration using Cold Fusion**** > > ** ** > > 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 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 database I receive the following > error which I cannot solve**** > > ** ** > > Anyone with any experience or advise using MYOB ODBC with a CF environment > I would love to hear your pearls of wisdom**** > > ** ** > > Oh the MYOB OBDC Driver is only available in 32 BIT**** > > ** ** > > Connection verification failed for data source: myob > java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC > Socket]internal error: Data source name not found and no default driver > specified > The root cause was that: java.sql.SQLException: [Macromedia][SequeLink > JDBC Driver][ODBC Socket]internal error: Data source name not found and no > default driver specified**** > > ** ** > > Regards > > Claude Raiola **** > > ** ** > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaussie@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en.**** > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaussie@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en.**** > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaussie@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > -- -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.