I don't know if this is possible or not with the BO, but I need to design an application that can be used with different database like VistaDB and MS-SQL.



The idea is that there will be customers that will use VistaDB mostly for single users and others will use MS-SQL for multiple users. Can a BO be setup to connect to either database? How?



P.S.

My understanding is that VistaDB database is pretty much compatible with MS-SQL TSQL language, they do not support all the features of MS-SQL of course, but at least it looks like they support all the standard features and if that is the case, then it may work for my project.

Edhy Rijo

I only hope I could use the DDT for VistaDB since all my BOs are mapped to the DDT excepts for views which could be a problem between VistaDB and MS-SQL.  Will start testing next week with VistaDB and would like to hear from Trent or Dustin about any possible issues with this scenario and RBS compatibility issues.

Edhy Rijo