Error 3706

Michael Barker · Post by **Michael Barker** » Thu Aug 30, 2012 9:14 am

Hi all,

I'm getting an error when I run my VBA code in Excel:

"Runtime error 3706: Provider cannot be found. It may not be properly installed".

Code: Select all

    Set cn = CreateObject("adodb.connection")
  strConnection = "Provider=TM1OLAP;Location=computername;Data Source=servername;"
  cn.Open strConnection, "admin", "password"

It bombs out on "cn.Open strConnection". I have been assured by the user that the appropriate drivers were installed.

Any help would be most appreciated.

Regards.