onClick works on one domain, but not another

C

Chumley Walrus

This may be a service pack issue, but uncertain as administrators are
on vacation, but I have an insert script thats insert button works on
one server, but not on another:
Here is the subroutine, followed by the onclick tag for the button:

Sub doInsert(Source as Object, E as EventArgs)
Dim MySQL as string = "Insert into Articles (articleheader,
articledate, articletext, sid) values (@articleheader, @articledate,
@articletext, @sid)"
Dim myConn As SqlConnection = New
SqlConnection("SERVER=xx.xx.xx.xx;UID=xx;PWD=xxxxxxxx;DATABASE=myDbase;")

Dim Cmd as New SQLCommand(MySQL, MyConn)

cmd.Parameters.Add(New SQLParameter("@articleheader",
frmarticleheader.text))
cmd.Parameters.Add(New SQLParameter("@articledate",
frmarticledate.text))
cmd.Parameters.Add(New SQLParameter("@articletext",
frmarticletext.text))

cmd.Parameters.Add(New SQLParameter("@sid", frmsid.text))
MyConn.Open()
cmd.ExecuteNonQuery
label1.visible="true"
BindData()
MyConn.Close()
label1.text = "Your data has been received!"
End Sub
''onclick button
<asp:button id="button1" Text="Insert" onclick="doInsert"
class="inputBox-or" runat="server" />

....this is part of an admin script that also includes an edit module,
and the edit module works as we are able to change articles on both
servers. I'm pretty sure that both servers are running .net framework
1.1

thanks for any help
chumley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,995
Messages
2,570,230
Members
46,819
Latest member
masterdaster

Latest Threads

Top