udanabanana
asked on
sample code using SQLite with VB6
Question Background
Im developing a POS(Point Of Sales) application. System Design to access several (average 6) POS computers from a BackEnd Computer. Data Including about 40000 products, 1500 supliers, 100 users, 1000 customers, and many transaction logins. At the moment system use text and dat files to keep data (Backend Data arround 1.5GB and Front End Data 500MB). Currently  BackEnd and POS use two sepeate applications, and seperate databases (well, I mean text and dat files). Now there is another program running all the time wich grabs data from POS side and update BackEnd. (Every 90seconds).
-------------------------- ---------- ---------- ---------- ---------- --
Now We came across SQLite.
1 Does Any one has Sample files connecting and creating SQLite3 database from VB6 ?
2 How we going to find and install SQLite drivers for VB6?
3 Do we need to add any refferences or Components?
Thank you for your concern
Udana
Please note Im a moderate VB / SQL programmer
Im developing a POS(Point Of Sales) application. System Design to access several (average 6) POS computers from a BackEnd Computer. Data Including about 40000 products, 1500 supliers, 100 users, 1000 customers, and many transaction logins. At the moment system use text and dat files to keep data (Backend Data arround 1.5GB and Front End Data 500MB). Currently  BackEnd and POS use two sepeate applications, and seperate databases (well, I mean text and dat files). Now there is another program running all the time wich grabs data from POS side and update BackEnd. (Every 90seconds).
--------------------------
Now We came across SQLite.
1 Does Any one has Sample files connecting and creating SQLite3 database from VB6 ?
2 How we going to find and install SQLite drivers for VB6?
3 Do we need to add any refferences or Components?
Thank you for your concern
Udana
Please note Im a moderate VB / SQL programmer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If you can have a look at this one too
https://www.experts-exchange.com/questions/21706106/SQLite-with-VB6-in-Windows.html