[PHP-DB] Help! SQL 2000 and cursors
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 -- 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]
[PHP-DB] 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" <[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, 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 > > -- 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]
[PHP-DB] PHP w/OOB
I have PHP compiled with OOB and Apache on one of my Linux bxes and it works great. My problem is that I need to run PHP w/ OOB on a second box as a stand alone app. Here is a sample script: #!/usr/local/bin/php Here is the error: X-Powered-By: PHP/4.0.4pl1 Content-type: text/html Warning: SQL error: [Easysoft ODBC (Client)]authentication error number 87, SQL state S1000 in SQLConnect in ./nessusscan on line 5 Error: unable to connect to SQL server This connect string works on all of my Apache servers. Is there some trick to this when PHP is stand alone? Thanks, Pat -- 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]