I'm really baffled by this one. I'mreally new to windows forms, my experience is with web forms. But . . . I've managed to design and deploy a project. It works great on my machine. I can connect to SQL, update table, do some file manipulations, and send an email.
I deploy it to the machine where I want it to run. And it does the file manipulations and sends the email - but no table updates. The connection string is in the app.config.
I get no errors. Nothing. I've built an ODBC connection on the machineand ittests fine. Nothing in the event viewer either on the workstation or the sql server. Here's the snipet of code. Can anyone guide me on what I'm doing wrong?
<add name="TAM.Translation.My.MySettings.Portal" connectionString="Data Source=mysqlserver;Initial Catalog=Portal;User ID=myuser;Password=mypwd" providerName="System.Data.SqlClient"/>
Try
Dim command1 As New SqlCommand("mystoredprocedurename")
command1.CommandType = CommandType.StoredProcedure
'Initiate connection to SQL source
Dim connection As New SqlConnection(My.Settings.Portal)
command1.Connection = connection
connection.Open()
command1.Parameters.AddWithValue("@SID", SID)
command1.ExecuteNonQuery()
connection.Close()
Catch ex As SqlException
DisplaySqlErrors(ex) ---------This traps nothing!
End Try
index > Windows Forms Data Controls and Databinding > SQL Connection