ADODB Interop

• • Reply

  17 years ago

  by dicer2000

  Brett

  Orange County, CA, United States

  Joined 17 years ago

  I'm having Interop "issues".  I need a clue!
  

  
  It is on a project where I have some legacy COM+ objects with which I have to work.  They require an recordset to be passed and they return a disconnected RS.  Here is how I do it:
  

  
  object objRS=null;
  ADODB.Recordset rs = null;
  strSQL = "SELECT...";
  objANFI.SQLQuery(strSQL, ref objRS);        // This works great
  

  
  // Now comes my "conversion" to a recordset
  rs = (ADODB.Recordset)objRS;    // This works on my development machine -- but won't deploy!
  

  
  Does anyone have a better way to do this?  Thank you in advance.
  

  
  Brett
  

  Report abuse