Link to home
Start Free TrialLog in
Avatar of udanabanana
udanabananaFlag for Australia

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
ASKER CERTIFIED SOLUTION
Avatar of JesterToo
JesterToo
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of udanabanana

ASKER

Thanks for the Help.. That was an uregent question.

If you can have a look at this one too

https://www.experts-exchange.com/questions/21706106/SQLite-with-VB6-in-Windows.html