>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