Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO error.
Message
 
To
13/11/2001 13:09:17
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00580990
Message ID:
00581318
Views:
20
The are the ADO Query Analyzer (has example to 'execute' Norwind SPT) and ADO Browser (Flores) utilities in the download section.

>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?
Imagination is more important than knowledge
Previous
Reply
Map
View

Click here to load this message in the networking platform