I am trying to create a webservice that access a SQL database. I receive the following error on the connection open method: "Referenced object has a value of 'Nothing'." I have attempted using both OleDB and SQL connection objects using hard coded DSN-less/DSN, Integrated Security/No Integrated Security + UID & PWD. I have changed the permissions on the database and in IIS. All to no avail.

I am sure that I am missing something simple but I can't figure it out. This is the connection declaration that I am using.

Dim oCN As New SqlConnection("Data Source=LOUSES2288; Initial Catalog=Development;Integrated Security=SSPI;")

oCN.Open()