Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADODB.Parameter in Win98
Message
 
 
To
30/11/2005 14:21:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01073375
Message ID:
01073384
Views:
16
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform