Connecting Tech Pros Worldwide Help | Site Map

Why? [Oracle][ODBC]Option value changed

  #1  
Old January 16th, 2007, 10:45 AM
Sonnich
Guest
 
Posts: n/a
I get this error:

Warning: odbc_exec() [function.odbc-exec]: SQL error:
[Oracle][ODBC]Option value changed., SQL state 01S02 in SQLExecDirect
in
C:\Inetpub\wwwroot\JOTIntranet\Modules\supplyservi ces\supplyservices_updateditems.php
on line 435

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result
resource in
C:\Inetpub\wwwroot\JOTIntranet\Modules\supplyservi ces\supplyservices_updateditems.php
on line 437

Here:
$result=odbc_exec($conn, $sql2);
$k=0;
while(odbc_fetch_row($result))

But only when I select a lot of data (say 2-3 days of data no problem,
but one week - I get this. 2 weeks and I get this a number of times.
The SQL2 is just a normal select blahblabhalll.

Can anyone give a hint?

BR
Sonnich

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re-logging into An Oracle Database Marvinq answers 3 December 1st, 2005 08:15 PM
Oracle Adventures Chris Botha answers 13 November 20th, 2005 12:03 AM
Recordset move error when accessing oracle 8.1.7 from VBScript mad answers 0 November 8th, 2005 08:25 PM
error after up loading the site Soha answers 3 July 30th, 2005 07:25 PM