ASP Classic, Passing Null to a stored Procedure

Glad you got it working. :)

"DEPearson" <webforumsuser@macromedia.com> wrote in message
news:f2i2qn$fsp$1@forums.macromedia.com...
>I just found the answer, the code above is for retrieving a record set
>where I
> have Set rs = etc.... Replace that line with
> remoteDB.Execute(sqlCommand).
>
> Appears to work now, have to check distance end.
>
> Thanks Lionstone, you got me thinking in the right direction.
>

I just found the answer, the code above is for retrieving a record set where I have Set rs = etc.... Replace that line with remoteDB.Execute(sqlCommand).

Appears to work now, have to check distance end.

Thanks Lionstone, you got me thinking in the right direction.

Here is the connection with command

'Create the object
Set remoteDB = Server.CreateObject("ADODB.Connection")

'Open the connection
strConnection = "Provider=SQLOLEDB.1;Server=XXXXXX.XXXXX.XXX,1435;Uid=XXXXXX;Pwd=XXXXXXX;Database=XXXXXXXXXX"
response.Write(strConnection)
remoteDB.Open strConnection
response.Write("<br/> connection is " & remoteDB.State & "<br>")
'remoteDB.State is returning 1 for good connection
'Insert the record here
sqlCommand = "procWebAddProspectOwner " & "1,25," & "HHTitle" & "','" & "HHFirstName" & "','" & "HHLastName" & "," &"NULL"& "," &"NULL"& "," &"NULL"& "," &"NULL"
response.Write(sqlCommand)
Set rs = remoteDB.Connection.Execute(sqlCommand, ,adCmdText)
'
The error is generated here. I take and copy the response.write output to SQL Query Analyer and the command works good.


'Close the connection
remoteDB.Close
response.Write("<br/> connection is " & remoteDB.State)
'If I comment out the sql command execute this State returns 0 indicating the connection is closed.

'Destroy the connection
set remoteDB = Nothing

The connection string is there, and looks good.
I ran a response.Write("<br/> connection is " & remoteDB.State & "<br>")
The results was 1 for good connection.