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?
"Patrick Brown" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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,
> FROM tblAccounting WHERE InvoiceDate = '" . $filterdate . "') AND
> < 3) AND (PaidDate IS NULL OR PaidDate <= '" . $filteryear . "') ORDER BY
> The server is a Redhat Linux server with PHP compiled standalone. It gets
> the SQL Server via the Easysoft OOB software.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]