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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
