Data enviroment and ASP

[eida_hanafiah]

Hi,
Can somebody tell me how to reference a command in data enviroment in ASP. FYI, I didn't enabled the scripting object model.


My command cmdInsert that accept parameters is a stored procedure name spInsertFeedback

I've tried this code, but it give me error....and it won't save to database.


<%
set DE=Server.CreateObject("DERuntime.DERunTime")
DE.Init (Application("DE"))

DE.cmdInsertFeedback "First Record"

%>

[KMG]

Hello,

I use connection strings like this, you may not need the session parts, I use many sessions so I do this.

Let me know if this helps you out.

Kenny

Set TEST= Server.CreateObject("ADODB.Connection")
TEST.ConnectionTimeout = Session("TEST_ConnectionTimeout")
TEST.CommandTimeout = Session("TEST_CommandTimeout")
TEST.Open Session("TEST_ConnectionString"), Session("TEST_RuntimeUserName"), Session("TEST_RuntimePassword")
Set CMD = Server.CreateObject("ADODB.Command")
Set RS = Server.CreateObject("ADODB.Recordset")