One way to create a quick test query in Windows via an ODBC connection is using the DQY format. To achieve this, create a DQY file (e.g. test.dqy) containing the magic first two lines (XLODBC and 1) as below, followed by your ODBC connection string on the third line and your query on the fourth … Read more
Got this error because I had the Data Source Name in User DSN instead of System DSN
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