From: [EMAIL PROTECTED]
Operating system: Windows 2000
PHP version: 4.1.1
PHP Bug Type: COM related
Bug description: Unsupported variant type: 8209 (0x2011)
Hi,
With PHP 4.0.6 on Windows 2000, i use this code :
$conn = new COM("ADODB.Connection");
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:/bdd.mdb;");
$rs = $conn->Execute("SELECT Libell� FROM [TV/Substrat]");
$num_fields = $rs->Fields->Count();
while (!$rs->EOF)
{
for ($i=0; $i < $num_fields; $i++)
{
$f=$rs->Fields($i);
$field_value=$f->Value;
echo "$field_value<br>\n";
}
$rs->MoveNext();
}
It works fine and the result is :
--------------------
CARB
HSS
HSS-E
HSS-E5
HSS-E8
HSS-EE
HSS-ES
HSS-PM
--------------------
But after installing the application software "IBM AS400 Client Access
Express", (but i can't proove actually, it's because of it), i've got this
message :
--------------------
Unsupported variant type: 8209 (0x2011)
--------------------
I think this software changed the ODBC drivers as i can see "Microsoft
Access Driver" and "Microsoft Access-Treiber" for example.
I updated PHP to 4.1.1 and the result for the previous code was :
--------------------
Array
Array
Array
Array
Array
Array
Array
Array
--------------------
When i print each element of an array i had something like this :
--------------------
670650820660
720830830
720830830450690
720830830450690530
720830830450690560
720830830450690690
720830830450690830
720830830450800770
--------------------
So, i understood it was ascii codes separated by "0". After applying CHR()
function to each element i have the right previous answer (CARB, HSS,
etc...).
Well, what's the trouble ?
Jean-Fran�ois GAZET (France)
--
Edit bug report at http://bugs.php.net/?id=15782&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=15782&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=15782&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=15782&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=15782&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=15782&r=support
Expected behavior: http://bugs.php.net/fix.php?id=15782&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=15782&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=15782&r=submittedtwice
