Perhaps you need to break up the string. Looking at an example from the KB,
both .Provider and .ConnectionString properties are set:

http://support.microsoft.com/default...19&Product=xlw


--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com




"Brad Wood" wrote in message
...
I use the following connection string in ADO objects
outside of Excel to connect to a SQLServer database and
run commands and it works fine:

"Provider=SQLOLEDB.1;Password=[];Persist Security
Info=True;User ID=sa;Initial Catalog=poptart;Data
Source=BWOOD\TROGDOR_DB"

When I set the connection string of an ADODB.Connection to
this and try to run a command, I get the error
message, "Requested operation requires an OLE DB Session
object, which is not supported by the current provider"

Anyone know why/what to change?