If any of you out there are useing ADO please give me the answer to this. I am doing a test to run a stored procedure through Fox using the following command and.
Oconnection = createobject("adodb.connection")
oConnstr = "Provider=SQLOLEDB; user ID=sa; password = sql001;"
oConnstr = oConnstr + "Initial catalog=bmsdev2; Data Source = dakota2"
Oconnection.ConnectionString = oConnstr
oConnstr = "Provider=SQLOLEDB; user ID=sa;"
oConnstr = oConnstr + "Initial catalog=bmsdev; Data Source = dakota2"
Oconnection.ConnectionString = oConnstr
"Here is where I create my parameter"
.Parameters.Append .CreateParameter("@praclocid", adChar, adParamInput, 9, "9697978")
I am getting the error variable "ADCHAR" not found.
Now 'adChar' is one of the parameters that ADO uses, why would I get thia error?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement