i thought they were filemaker pro databases? _____
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Simon Haddon Sent: Tuesday, 4 March 2008 5:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: MYOB as a datasource - has anyone done it? Hi Mike, Funny enough I am interested in doing the same thing. My understanding is that a registration key is required but that the database is a standard MS access database and so should just work. If I learn anything new I will tell you. Cheers, Simon On 04/03/2008, Mike Kear <[EMAIL PROTECTED]> wrote: 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 Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
