Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invoke Stored Procedures from ASP
Message
From
29/08/2000 20:05:01
Kenneth Downs
Secure Data Software, Inc.
New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Invoke Stored Procedures from ASP
Miscellaneous
Thread ID:
00410560
Message ID:
00410560
Views:
36
Can ASP invoke a Foxpro stored procedure?

I've got the following bit of code running OK, that I lifted from MSDN:
  Set oCN = Server.CreateObject("ADODB.Connection")
  ConnStr= "Driver=Microsoft Visual Foxpro Driver; " _
    & "UID=;SourceType=DBC;SourceDB=e:\inetpub\wwwroot\app2\foxdata.dbc"
  oCn.Open ConnStr
  SET cmdStored = Server.CreateObject("ADODB.Command")
I have created a simple stored procedure called Stored_Procedure, that does not do anything. I cannot get any of the following to work:
cmdStored.CommandText = "Stored_Procedure"
cmdStored.CommandText = "Stored_Procedure()"
cmdStored.CommandText = "=Stored_Procedure()"
It seems that OLE DB really wants me to return a record set, as I have no trouble with a command text of "SELECT * FROM AnyTable"

It also seems that if I cannot execute stored procedures, the world appears to close in on me.

Any help?

As always, TIA...
Next
Reply
Map
View

Click here to load this message in the networking platform