Cannot connect to SQL Server database

[TanyaSealey]

I've created the following:

Dim objConn, objCommand, objQry

Set objConn = Server.CreateObject("ADODB.Connection&quot
Set objCommand = Server.CreateObject("ADODB.Command&quot

objConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=DATABASE;Integrated Security=SSPI;Initial Catalog=ProspectUs;OLE DB Services=-2"
objCommand.ActiveConnection = objConn

However the objCommand.ActiveConnect = objConn line fails every time. The current error message is 0x800A0E7D: Requested operation requires an OLE DB Session object, which is not supported by the current provider.

Does anyone know where I've gone wrong...?!

Thanks.

 

[Chopstik]

Should you first open the connection and then try to set your command object to the connection?

objConn.open
objCommand.ActiveConnection = objConn

--------------------------------------------------------------------------------------------------------------------------
Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
--Douglas Adams