How can I check VFP OLE DB Provider version and MDAC versin installed ?


>What VFP OLE DB provider version are you using? What MDAC version do you have on Win98? Did you try to install the latest one?
>
>>
>>When I try to use parameter in VFPOLEDB Provider in Win98 it generate the OLE IDispatch exception code 0 from Provider: Sinalizador de conversão inválido error message.
>>
>>- In WinXP or 2k works so good
>>- If I don't use parameters WinXP or 2k works so good in Win98 too.
>>
>>

>>loConn = Createobject([ADODB.Connection])
>>loCmd  = Createobject([ADODB.Command])
>>***
>>lsDataBase = "C:\MyDataBase.DBC"
>>Text to lcString textmerge noshow pretext 1
>>  Provider=VFPOLEDB.1;Data Source=<<lsDataBase>>;Password="";Collating Sequence=MACHINE
>>EndText	
>>loConn.ConnectionString = lcString
>>loConn.Open()
>>loCmd.ActiveConnection = loConn
>>***
>>lsSql = "Select id from customer where id = ?"
>>loParameter = loCmd.CreateParameter("pPar", 3, 1, 10, 19)
>>loCmd.Parameters.Append(loParameter)
>>***
>>loCmd.CommandText = lsSql
>>loRs = loCmd.Execute() && Generate error
>>***
>>loConn.Close()
>>