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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only