Migrating from Visual Basic 3 SQL 4.0 to Visual Basic 5.0 and/or SQL Anywhere

Migrating from Visual Basic 3 SQL 4.0 to Visual Basic 5.0 and/or SQL Anywhere

Post by Optiona » Tue, 21 Jul 1998 04:00:00



We have a Visual Basic 3.0 project currently using Watcom SQL 4.0 on several
different platforms.  We would like to bring this project forward to newer
versions VB and SQL.  Can anyone answer these questions:

1) Would our existing VB 3.0 project that makes Watcom specific calls to the
database (not ODBC) be supported by latest SQL Anywhere package?  Or, would
we have to re-write all the code?

2) Has anyone gone through this process, and if so, did you find the
transition easy or a nightmare?

3) Are the any unexplainable issues with the latest SQL Anywhere that have
disabled your database, corrupted data or brought your software to a sudden
halt?

4) Does the SQL Anywhere product support replication with 'Rules' that allow
us to move data/orders from one site to another with ease?  Can it do this
one the Internet with encrypted data transfer.

5) Are we better to explore VB 5.0 and MS Access / SQL Server ???

Any answers would be welcomed.

Thanks,

Kevin Dalby