How to connect to a SQLite data source via ODBC
RESOLUTION
1. Open Toad Decision Point
2. Click Add data (LHS)
3. Select Toad Data Services and press OK
4. Click Manage Data Objects
5. Click the Create a Data Source icon
6. Give it a name and select 'Generic ODBC'. the datasources that appear here match the data sources that are in your ODBC Source Administrator Console
7. Select ToadSample from the list, if this does not exist type 'DSN=ToadSample' in the connection string field
8. Enter username/password if required to connect to Data Source
9. You will now see your Data Source on the list, please expand this and go to 'Mappable Objects'
10. Select the tables that you want to be visible and right click on select 'Map Table' and press OK
11. Your tables will now appear under the Tables node under your Data Source Name
12. You will now see the tables in Toad Decision Point
