I am trying to develop the customized webpart for SPS v2. When i use Connection
object which is part of ADODB, and deploy the webpart SPS throwing the error.
Same thing I used in c# web application, it is working fine.

My questions are:
a) Do we have to place ADODB.dll library in particular folder
b) how we can mention about the DataSource and user id and Password?. In
standard web application i am using
ADOMD.Cellset cellSet = new ADOMD.Cellset();
ADODB.Connection cn = new ADODB.ConnectionClass();
cn.Open("Provider=msolap;Data Source=localhost;Initial Catalog=Foodmart
2000","","",0);