Mike, Setup a blank access db - link tables to myob using a ODBC connection. Check the case sensitivity on the tables within myob after linking. Run queries using the access db then port them into CF once successful. Worked this way for me.
Hth Rod -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Tuesday, 4 March 2008 5:32 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: MYOB as a datasource - has anyone done it? yes i have a ODBC DSN set up in the WinXPPro administration tools MYOB provide a connection test app, (click and it says "DSN OK" or "DSN Failed"). So i set up the ODBC DSN in WIndows, and checked it worked with the tool. Yes it did. So i went to the CF8 administrator and set up a DSN there, linking using the ODBC Connector to the DSN mentioned in the previous paragraph. Worked ok, Clicked the "ok" button and got "OK" result. Beauty! I thought - this is going great guns. Next step - go to the site and make a test page with a simple query in it, and CFDUMP of the result - to check it all works that far. BUMMER! Back to the CFAdministrator - is the DSN still working? Click the OK button - get "OK". So it looks to me like Coldfusion is connecting to the MYOB database, but running a query on it, even a simple select query not an insert or update breaks something, or alternatively it's not set up properly, somehow. I've called the MYOB support area and they dont know anything about Coldfusion (surprise surprise) but they verified that I have the datasource configured correctly, at least as far as it gets to ColdFusion. Once i got to talkilng about anything to do with ColdFusion they just went blank, 'sorry can't help you'.. So that's why i'd really like to hear from anyone who has actually managed to make a CFQUERY work on a MYOB datacource. I havent been able to confirm that if i set it up correctly it will indeed work. I dont want to spend ages working on this if it's goign to end up that there's some imcompatibility between CF and MYOB or something and it's never going to work. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Mar 4, 2008 at 5:22 PM, Steve Onnis <[EMAIL PROTECTED]> wrote: > > Have you tried using an ODBC Socket connection and connecting to that in CF? > > > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
