Connecting To Database - Object Reference Not Set Error Message

I've got code that on my own machine (visual studio .net 2003 and iis and sql server all exist on this box) works great. I display my test page, which loads a dropdownlist on page_load. This works great on my own machine.





When I move the code to our dev environment. Web server and database servers on separate boxes. I get the error "Object reference not set to an instance of an object" when i try to open the connection to the database. I thought it had to do with permissions and I check all through sql server and everything looks great. I then thought it was the connection string. I still haven't ruled this out, but I wrote a quick vbscript app to attach to the database and try to pull a record. The vbscript worked fine. So, the code works fine on my computer, but not on the web server. The connection does work with vbscript, but through my asp.net web app I get the "object reference" error.





All code below...





ASP.NET webpage:


private void Page_Load(object sender, System.EventArgs e)


{





if( !IsPostBack )


{


// Create a command object for the query


string mySelectQuery = "select id from vw_abcd order by ID";





SqlCommand myCommand = new SqlCommand(mySelectQuery,sqlConnection1);


sqlConnection1.Open();





DropDownList1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);


DropDownList1.DataBind();


sqlConnection1.Close();





RangeValidator1.MinimumValue = "1";


RangeValidator1.MaximumValue = DropDownList1.Items.Count.ToString();


}


}





Connection string on my machine:


workstation id=wXXXXXX01;packet size=4096;user id=testuser;password=testpass;integrated security=SSPI;data source=wXXXXXX01;persist security info=False;initial catalog=TestDB"/>





Connection string on web server:


network library=DBMSSOCN;data source=xxx.xx.xxx.xxxinstance1;user id=testuser;password=testpass;initial catalog=TestDB








vbscript:


Dim connConnection, rstresultset


strConnectionString = "driver={Sql Server};server=xxx.xx.xxx.xxxinstance1;user id=testuser;password=testpass;database=TestDB"





Set connConnection = CreateObject("ADODB.Connection")





connConnection.Open strConnectionString


Set rstresultset = createobject("ADODB.Recordset")





rstresultset.ActiveConnection = connConnection





rstresultset.Open "select id, comment from testtable", connConnection





msgbox rstresultset(0)


msgbox rstresultset.Fields(0).Value











Error message and stack trace:


Object reference not set to an instance of an object.





at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)


at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)


at System.Data.SqlClient.SqlConnection.Open()


at Web2.Drilldown.Page_Load(object sender, System.EventArgs e)














Any ideas what's going on?????