I have strange problems accessing MSSQL over COM over ADO over OLEDB 
In the script below produces the last sql-statement the sql-error (MSSQL 
Errornumber: 242)
 > Warning*: Invoke() failed: Ausnahmefehler aufgetreten. *Source* : 
Microsoft OLE DB Provider for SQL Server *Description* : Bei der 
Konvertierung eines
 > char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert 
außerhalb des gültigen Bereichs. in *D:\adocrash2.php* on line *38*

but the statement is correct. If I use the same recordset no problems, 
but If I use new recordset but with the same Connection, then this error 
occurs the third time opening a new recordset with the same connection. 
I also tries to set again (SET DATEFORMAT ymd), but this statement has 
no effect anymore.

This seems to be a problem with the COM-Module in PHP,



$conn = new COM( "ADODB.Connection" );
$rs = new COM( "ADODB.Recordset" );
$conn->Provider = 'SQLOLEDB';
$conn->Open( "Server=wincubix;Uid=oebb;Pwd=oebb;Database=cubix" );
$conn->Execute('SET DATEFORMAT ymd');
$rs->ActiveConnection = $conn;
$rs->Open("SELECT DISTINCT * FROM news WHERE gueltig_von <= '2002-05-13'");

echo '<table>';
while (!$rs->EOF) {
    echo '<tr>';
    for ($i=0; $i < $rs->Fields->Count; $i++) {
           echo '<td>';
        echo $rs->Fields[$i]->Value;
           echo '</td>';
    echo '</tr>';
echo '</table>';

$rs->Open("SELECT DISTINCT * FROM news WHERE gueltig_von <= '2002-05-13'");

$rs->Open("SELECT DISTINCT * FROM news WHERE gueltig_von <= '2002-05-13'");

$rs2 = new COM( "ADODB.Recordset" );
$rs2->ActiveConnection = $conn;
$rs2->Open( "SELECT DISTINCT * FROM news WHERE gueltig_von <= 


Michael Bretterklieber
JAWA Management Software GmbH
Liebenauer Hauptstr. 200
A-8041 GRAZ
Tel: ++43-(0)316-403274-12
Fax: ++43-(0)316-403274-10
GSM: ++43-(0)676-93 96 698
homepage: http://www.jawa.at
--------- privat -----------
homepage: http://www.inode.at/mbretter
"...the number of UNIX installations has grown to 10, with more expected..."
           - Dennis Ritchie and Ken Thompson, June 1972 

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to