New Posts New Posts RSS Feed: Databases That Are Compatible with DevForce
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Databases That Are Compatible with DevForce
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
Customer View Drop Down
Senior Member
Senior Member
Avatar
User Submitted Questions to Support

Joined: 30-May-2007
Location: United States
Posts: 260 		Post Options Post Options   Quote Customer Quote  Post ReplyReply Direct Link To This Post Topic: Databases That Are Compatible with DevForce
    Posted: 30-May-2007 at 4:32pm

Do you have a list of databases -- - other than SQL Server -- that you know work well with DevForce?  Also, do you know if SQL Server 2000 works well with DevForce?

 
Back to Top
IdeaBlade View Drop Down
Moderator Group
Moderator Group
Avatar

Joined: 30-May-2007
Location: United States
Posts: 353 		Post Options Post Options   Quote IdeaBlade Quote  Post ReplyReply Direct Link To This Post Posted: 30-May-2007 at 4:35pm

We have customers using all of these databases:

  • Oracle 8, 9i, 10g
  • DB2
  • Sybase SQL Anywhere
  • Informix
  • SQL Server 2000.

There are almost certainly others that will work, as well.  If the database is ANSI-92 compliant and the manufacturer (or someone) has created an OleDb provider that fully implements the OleDb spec, the chances are good that we can work with it.

 

Why doesn’t DevForce support the Microsoft Access JET engine database?

For the databases it supports, DevForce generates ANSI-92 SQL.  JET’s version of SQL is not ANSI-92 compliant, so to support it we would have to write a lot of special-case code; and since DevForce targets enterprise, multi-user applications for which JET is neither designed nor well-suited, there is little motivation to do so.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down