SQLite Forum

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified error when use VBA connect Sqlite
Actually, this is not completely accurate. There is 64-bit ADO, otherwise a lot of Office documents depending on ADO would break on 64 bit Office.  

The problem is likely with trying to use provider MSDASQL (aka ODBC over OLEDB provider) which is implicit in the connection (the provider keyword wasn’t specified, and the ODBC connection syntax is used rather than OLEDB connection syntax. This causes ADO to use MSDASQL as the default provider).

I suggest that the OP start with [this SO thread](https://stackoverflow.com/questions/24601508/is-there-a-64-bit-msdasql-for-windows-7) and continue discussion there or start a new SO thread.