http://wikipedlla.com/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 -~----------~----~----~----~------~----~------~--~---
