I haven't used this particular system but in the past ive worked with an ODBC implementation or another industry-based accounting package. Basically it was crap. Horribly slow at doing anything other than raw selects from 1 table. some joins could take up to 30seconds to run.
Our solution was to take nightly dumps of the tables into SQL server and then query the SQL box from CF. The funny thing was about 6 months later the company produced a SQL Server export package that did exactly the same thing. So be very careful with using propietary ODBC connections. They are usually implemented to make it easy to dump out to excel or something. not for robust web-based applications. my 2c Pat On Nov 28, 8:29 am, "Carl Vanderpal" <[EMAIL PROTECTED]> wrote: > Well according to my assiciate the odbc is a little buggy..so I was > wondering if any have successfully integrated this one [or another] into a > system? If another one can you pass on the details.. > > Thanks > > On 11/27/06, ACTCFUG <[EMAIL PROTECTED]> wrote: > > > > > Try talking to the database - get data dumps - be careful about how you > > get the data and use it. CF should be quite capable of talking to any > > ODBC compliant application.-- > ==================================== > Postal: Po Box 3462 Dural, NSW 2158 > Email: mailto:[EMAIL PROTECTED] > Skype: skype:carlos-amigos?call --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
