DBkit for web and ODBC

General
1

Hi,

I am looking into Xojo as a new tool for webapps. My database can be reached through ODBC.

Is this type of connection available in DBkit for web?

Thank you

2

Yes, ODBC is supported. What kind of database is it?

3

Hypersql - the one bundled with windev. We are moving away from windev to xojo due to licensing issues. Most of our databases are mysql but a few are hypersql.

4

I’m not familiar with that one but any standard SQL database engine should work. I have had to make a few changes for PostgreSQL and MySQL because of how they operate primarily in how they handle getting the primary key after an insert. SQLite OTOH for example has not required any special code.

Let me know if you run into any problems. It may be that I will need to raise an event so that should an engine accessed via ODBC has a unique issue with getting the primary key after an insert, there will be a way for you as the developer to add a line of code to provide that.