I am trying to connect to an SQL 7 database using the connectionstring in asp using the following code<BR><BR>Dim conn<BR><BR>&#039;set conn = server.CreateObject ("adodb.connection")<BR>&#039;conn.Open "Spam", "SPAMWeb", "password"<BR>set conn = server.Createobject ("adodb.connection")<BR> conn.ConnectionString = "driver={SQL Server};" & _<BR> "DATABASE=Spam;UID=SPAMWeb;PWD=password;" & _<BR> "SERVER=localhost"<BR><BR>When I run the code I get the following error <BR><BR><BR>ADODB.Connection error &#039;800a0e78&#039; <BR><BR>The operation requested by the application is not allowed if the object is closed. <BR><BR>/Spam/testing/databasetest.asp, line 23 <BR><BR>Can anyone help me with this<BR><BR>cheers Mal