Tom See below
> -----Original Message----- > From: Tom Chiverton [mailto:[EMAIL PROTECTED] > Sent: 04 March 2008 16:23 > To: CF-Talk > Subject: Re: CF8 datasource problem > > On Tuesday 04 Mar 2008, Richard Meredith-Hardy wrote: > > An ODBC connection to a SAGE line-100 accounts database works > > perfectly > > What database ? Sage's own one ? I believe so, yes. Unfortunately if you do a search on SAGE line 100 and ODBC and 'flaky' or 'unreliable' you get a suprising lot of answers for what is supposed to be 'Britain's No. 1 accounts software'. Also, rather unfortunately I have no option (apart from my efforts to pursuade my client to upgrade his accounts system to something a bit more modern). It does seem to be a bit of a dead-end this one, one hint I found is that the sage ODBC driver isn't ODBC 3 compliant which may explain why it works in CF5 but not CF8 Nevertheless, I was hoping someone might have found a solution..... If not, then I'll have to keep CF5 going, doing regular loads into an intermediate mssql db. Not ideal, but workable. > > > VENDORERRORCODE 2217 > > What does this code mean ? I've absolutely no idea. SAGE charge £1500 for the SDK. > > > Additionally, when I get this error, on the server I get a Visual > > studio Just-in-Time Debugger window popping up with the message: An > > unhandled exception occurred in swsoc.exe [6138] > > What's that .exe ? Why is Studio running/installed ? "swsoc.exe is a process associated with the Cold Fusion server from Macromedia" Studio: I don't really know, something to do with MSSQL server perhaps? This is my dev box, the 'Business intelligence development studio' is all part of the studio empire isn't it? > > -- > Tom Chiverton > Helping to quickly benchmark scalable applications > on: http://thefalken.livejournal.com > > **************************************************** > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered > in England and Wales under registered number OC307980 whose > registered office address is at Halliwells LLP, 3 Hardman > Square, Spinningfields, Manchester, M3 3EB. A list of > members is available for inspection at the registered office. > Any reference to a partner in relation to Halliwells LLP > means a member of Halliwells LLP. Regulated by The > Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee > named above and may be confidential or legally privileged. > If you are not the addressee you must not read it and must > not use any information contained in nor copy it nor inform > any person other than Halliwells LLP or the addressee of its > existence or contents. If you have received this email in > error please delete it and notify Halliwells LLP IT > Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4