odbc – Make Me Engineer

what is the difference between OLE DB and ODBC data sources?

July 9, 2022 by Tarik

According to ADO: ActiveX Data Objects, a book by Jason T. Roff, published by O’Reilly Media in 2001 (excellent diagram here), he says precisely what MOZILLA said. (directly from page 7 of that book) ODBC provides access only to relational databases OLE DB provides the following features Access to data regardless of its format or … Read more

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

June 30, 2022 by Tarik

In reference to the error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. That error means that the Data Source Name (DSN) you are specifying in your connection configuration is not being found in the windows registry. It is important that your ODBC driver’s executable and linking format (ELF) is … Read more