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