Thanks Steve. We have paid for the access, and have a valid key. I checked that with MYOB.
Do you konw if a CFQUERY will work if we set the rest of it all up correctly? or do i have to forget using CFQUERY and code the connection strings myself using <cfscript>? On Tue, Mar 4, 2008 at 4:59 PM, Steve Onnis <[EMAIL PROTECTED]> wrote: > > You have to pay for the access to it. The normal myob does not let outside > application do antyhing with it. You have to pay for a driver for it and > even then you get different levels, either a select or > select/update/insert/delete driver. So I would say the the database itself > is not allowing cf to access it, even though it connects successfully > > Steve > > > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Mike Kear > Sent: Tuesday, 4 March 2008 4:56 PM > To: cfaussie > Subject: [cfaussie] MYOB as a datasource - has anyone done it? > > > Has anyone successfully managed to connect to MYOB as a datasource and run > coldfusion queries against it? > > I've got the write access key and verified i have a valid DSN in my control > panel (WInXPPro) and the CF8 Administrator has a DSN configured, which shows > 'OK" when I click the 'test DSN' icon. So far, so good. > > But when i create a CFM page and use that dsn name (imaginatively named > testMYOB) i get an error message. > > The query's simple enough - all i want to do is test it all at this stage - > it's as follows: > > <cfquery name="firstquery" datasource="aatestMYOB"> Select * from Customers > </cfquery> <cfdump var="#firstquery#" > > > But i get the following error when I do: > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Driver does > not support this function > > > Has anyone else seen this? Does a CFQUERY actually work on a MYOB > dsn? Do i have to set up a datasource connection string etc > manually in the .CFM page? > > The version is MYOB v17, MYOB ODBC driver is v7.00.00.04 if it makes > any difference. > -- > 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 > > > > > > > -- 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---