Hi George!
You are EXACTLY right, and if Jon implements some kind of ADO solution, I'm fine with that, but I don't think their SQL light does.
Lytec is still using VB6, that's true, but the migrated 2 years ago from Pervasive's database engine (in other words, relabeled B-trieve, if I remember correctly) to MS SQL. When they did, database reliability went out the window. While the dropped connections do not corrupt the database (at least they got THAT part right), when the connection drops the program does not recover gracefully. I would hate to see Amazing Charts wind up in that situation, as we LIVE in Amazing Charts.
Amazing Charts is written in VB6, and quite frankly while MS Jet is ancient technology, it gets the job done and has been solid as a rock, even if it's slower than sin. While I'd love to see a migration to a newer database engine, I don't want it to be move that causes instability on systems like mine which use wireless connections.
Regards,
V.
