Error 3706
Posted: 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".
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.
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"Any help would be most appreciated.
Regards.