Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADODB.Parameter in Win98
Message
 
 
À
30/11/2005 14:21:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01073375
Message ID:
01073384
Vues:
17
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()
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform