Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Going crazy with ASP
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00570258
Message ID:
00570339
Views:
21
>Hi there, here I am once again with the same question...
>I don't know how to get a value sent back from a stored procedure via ASP.
>I red some examples and tried them but without success.
>
>I tried this program in VFP and it works :
>
>Local NPROC,oConnection,Istr
>oConnection = CreateObject("adodb.connection")
>NPROC = "Mystoredproc(param)"
>With oConnection
> .ConnectionString = [Provider=VFPOLEDB.1;Data Source=MYDATABASE.DBC;]
> .Open
> istr = .execute(oproc)
>Endwith
>? "return value : " + istr.fields(0).value
>istr.close()
>oconnection.close()
>
>
>The fact is that it doesn't work in ASP...please help me before it's too late
>
>Thank u so much
>Alessio
What ASP code are you using? I am assuming you are trying to access the data directly from an asp script without calling a VFP dll otherwise you would not have any real use for VFP tables in ado.

Is the database on the local PC or the network. The default asp user will not have access to a network file.
Bill Mittenzwey
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform