Start Date: 4-24-2009
Stop Date: Not available until all requirements are developed and time estimates accrued.
2009-4-24
- Interviewed customer about project, requirements, and cost. Customer will assemble list of written requirements and email those to me. In the meantime, I’ll start working on parts of project that I know will be needed, even without their list of requirements.
2009-4-25
- Developing requirements further and initial table structures.
- Developed primary forms and table schemas to handle customer tracking.
2009-4-26 to 2009-4-29
- Successfully recompiled sqlite3.dll into uds3.dll (Usleton Data Systems)
- Successfully recompiled sqlite3odbc.dll into uds3odbc.dll. Now uses my company information AND displays my chosen name for it under Windows ODBC Data Sources list.
- Tested newly renamed sqlite ODBC driver with creating tables, indexes, and views, plus adding, updating, deleting, and joining data among the tables using ADO. Works like a charm!
- Debating adding Win32 code to uds3.dll in order to not use an ODBC driver. Would just pass SQL directly into Public Declare function-names used. Haven’t verified form of row-returning queries (recordset?, arrays?, something else?).
- Downloaded 2 drivers from datenhaus website (http://www.thecommon.net/) in order to instantiate ODBC driver without having to EVER register ODBC driver in registry. This will bypass a major issue I’ve encountered in previous years where customers have locked-down registries, especially in corporate environments. Not a problem now!
- Need to check with customer on progress of requirements they’re assembling.
- Side Note: Time to develop my own ODBC driver for accommodating AS400 and UN*X. Already exists, I know, but why waste money and time buying them when you can learn how to build them and then sell them? Opportunity just waiting.
