I have a program that interfaces with my Palm. The windows side was written in VB6 with access database, on the Palm side I used NSbasic (very good). Then I have a third party software that builds the Palm conduit. This third party software uses ODBC to interface the two programs. I would like to re-write the program using PB and started down that road only to find that you can not get the OBDC driver to go backwards in the dataset. So I thought that I would try a SQlite it works but the third party software does not like it nor does Excel, it seems to miss one record set completely. Then I moved on to MYSQL however I found that one very confusing, I could not seem to find anywere a program to create a simple test database. So I guess my questions are these.
1) can someone recommend a good database that has a workig ODBC.
2) can someone give direction in getting mysql to work.
3) does someone know how to get the ODBC for access to go backwards.
4). has someone used the ODBC for SQLite and got it to work with Excel.
Thanks in advance.
Blair..