SQL Error: ADODB.Command error '800a0bb9'

[smdev-DgYjQr]

I am trying to insert information into a MS SQL database using a for I created Dreamweaver 8, but every time I receive the following message:
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/index_ibst_emp_man_ins_rec.asp, line 113

This is a copy of my code:
If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> "") Then
Response.Redirect(MM_editRedirectUrl)
End If
End If

End If

If a copy of the code for the entire site is needed I can post that also.

[Newsgroup_User]

Generally, that results from not having a connection string defined for the
command. Make sure you've uploaded your /Connections folder to whatever
server you're using to view the page.


"smdev" <webforumsuser@macromedia.com> wrote in message
news:el064r$olo$1@forums.macromedia.com...
>I am trying to insert information into a MS SQL database using a for I
>created
> Dreamweaver 8, but every time I receive the following message:
> ADODB.Command error '800a0bb9'
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
> /index_ibst_emp_man_ins_rec.asp, line 113
>
> This is a copy of my code:
> If (Not MM_abortEdit) Then
> ' execute the insert
> Set MM_editCmd = Server.CreateObject("ADODB.Command")
> MM_editCmd.ActiveConnection = MM_editConnection
> MM_editCmd.CommandText = MM_editQuery
> MM_editCmd.Execute
> MM_editCmd.ActiveConnection.Close
>
> If (MM_editRedirectUrl <> "") Then
> Response.Redirect(MM_editRedirectUrl)
> End If
> End If
>
> End If
>
> If a copy of the code for the entire site is needed I can post that also.
>
>