Re: Help! SQL 2000 and cursors

I just tried installing MDAC 2.7 on my SQL Server, based on another user's recommendation. That didn't resolve the problem. Any other ideas? Thanks, Pat "Patrick Brown" <pbrown@sla.com> wrote in message news:20020115000720.33003.qmail@pb1.pair.com... > I've been running a PHP4 script on a Linux server every day for quite a > while now. All of a sudden, it stops working. The error message is: > > [ODBC SQL Server Driver][SQL Server]The cursor was not declared. > > What does this mean and how can I fix it? Nothing has changed as far as I > know. Nobody else has access. > > Here is the SQL statement that generates the error: > > $sql = "SELECT acctid, invoicedate, paiddate, annualdate, reminder, memtype > FROM tblAccounting WHERE InvoiceDate = '" . $filterdate . "') AND (reminder > < 3) AND (PaidDate IS NULL OR PaidDate <= '" . $filteryear . "') > ORDER BY > acctid"; > > The server is a Redhat Linux server with PHP compiled standalone. It gets to > the SQL Server via the Easysoft OOB software. > > Thanks, > Pat > >