Financials and OLE DB

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 :slight_smile: 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;