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.
RE: [cfaussie] MYOB ODBC Read Integration using Cold Fusion
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 mailto: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.
Re: [cfaussie] MYOB ODBC Read Integration using Cold Fusion
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