Is there anybody here who has already used the ‘Microsoft OLE DB Service Component 1.0 Type Library’ in Financials and can send me an example codeunit that shows how to open a OLE DB connection and get data with it?
I don’t know if this is any help to you, using the Microsoft ActiveX Data Objects 2.0, but it works 
CREATE(AdoRec); CREATE(AdoConn); DsnString := ‘Provider=SQLOLEDB.1;Data Source=Thunkpadd;Initial Catalog=pubs;User Id=sa’; AdoConn.Open(DsnString,’’,’’,’’); SqlString := ‘SELECT * FROM authors’; AdoRec.Open(SqlString,AdoConn,1,3); IF AdoRec.EOF = FALSE THEN BEGIN REPEAT AdoFields := AdoRec.Fields; AdoField := AdoFields.Item(0); MESSAGE(FORMAT(AdoField.Value)); AdoRec.MoveNext; UNTIL AdoRec.EOF = TRUE; END; AdoRec.Close;