reading database with ADOB

[pelegk2]

i tried this code to read from access DB
and when i access a cell that is empty and not null with this code :

name =_strdup((char*) ((_bstr_t)(pConnectRead->GetFields()->GetItem("name")->GetValue())) ); 

then i get an error : type mismatch
why is that?
thnaks in advance
peleg

[Norby mahoney]

i tried this code to read from access DB
and when i access a cell that is empty and not null with this code :

name =_strdup((char*) ((_bstr_t)(pConnectRead->GetFields()->GetItem("name")->GetValue())) ); 

then i get an error : type mismatch
why is that?
thnaks in advance
peleg

Try this:

COleVariant Var;
Var = recordset->Fields->GetItem("FirstName")->Value;
firstName = ( Var.vt == VT_NULL ? _T("") : ((char *) (_bstr_t)Var.bstrVal) );

This above code definitely works.

Hope this helps.