Re: CF8 datasource problem

2008-03-05 Thread Tom Chiverton
On Tuesday 04 Mar 2008, Richard Meredith-Hardy wrote: 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'. You get the same for the

CF8 datasource problem

2008-03-04 Thread Richard Meredith-Hardy
An ODBC connection to a SAGE line-100 accounts database works perfectly well in CF5 but I can't get it to work at all in CF8 on the same server. (Win2k3 R2 sp2) In CF8, it shows OK in the status column of the Data sources page, also when I 'verify' it, but when I run a query from a page which

Re: CF8 datasource problem

2008-03-04 Thread Tom Chiverton
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 ? VENDORERRORCODE 2217 What does this code mean ? Additionally, when I get this error, on the server I get a Visual studio

RE: CF8 datasource problem

2008-03-04 Thread Richard Meredith-Hardy
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