connection not initialized
Hello and thank you for taking a moment to read this message. I get the following error when I go to execute this Insert for an image into SQL Server: The ConnectionString property has not been initialized.
Can anybody tell me is the error in my code or is it perhaps in the way I have my permissions set up in SQL Server. (I am fairly new in working with sql server) Any suggestions would be greatly appreciated.
Thanks,
Jason
<Script>
Sub Page
' Create Instance of Connection and Command
Object Dim objConn As SqlConnection
objConn = New SqlConnection( "Server=localhost;uid=jazzcatone;pwd=funkdafied;da tabase=Beatles" )
Dim myCommand As New SqlCommand("sp_person_isp",objConn)
<then do a whole bunch of stuff and then....>
Try
objConn.Open()
myCommand.ExecuteNonQuery()
objConn.Close()
Response.Write("New person successfully added!")
Catch SQLexc As SqlException
Response.Write("Insert Failed. Error Details are: " & SQLexc.ToString())
End Try
End Sub
|