Re: [OT] Sybase vs. Pervasive SQL for WebDNA integration?

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60982
interpreted = N
texte = WJ Starck wrote: > I plan to develop Web based WebDNA templates that will gather patient > data for one of these two vendor's programs - is Pervasive or Sybase a > preferred choice for ease of integration with WebDNA? I have not used Sybase, but I have used Pervasive and I couldn't recommend it at all. Pervasive was originally part of Netware and was spun off to its own product line. At the time, it was an embedded database (i.e. it was designed to be compiled directly into the application itself), so it was clearly not client-server. I don't know if they have changed that in the 5 years or so since I used it (with a financial package called Solomon). AFAIK, Pervasive is a shared access database (multiple processes can cooperatively access the database files) as opposed to a client-server (server process mediates access for multiple client processes). As far as what the marketing literature for PracticeWorks states, those are indeed the most common commercial client-server databases (they are excluding MySQL and PostgreSQL because they are not "commercial" but not because they are not client-server, which they both are). As I said, I have not used Sybase, but you are not going to be able to easily integrate it with WebDNA, since you are going to be limited to ODBC connections (only MySQL is supported natively by WebDNA). You should be sure that the Sybase application has good ODBC support and that you have access to the schema. Don't expect the vender to be all that much help trying to insert data into their databases... HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [OT] Sybase vs. Pervasive SQL for WebDNA integration? ( Gary Krockover 2005)
  2. Re: [OT] Sybase vs. Pervasive SQL for WebDNA integration? ( John Peacock 2005)
  3. [OT] Sybase vs. Pervasive SQL for WebDNA integration? ( WJ Starck 2005)
WJ Starck wrote: > I plan to develop Web based WebDNA templates that will gather patient > data for one of these two vendor's programs - is Pervasive or Sybase a > preferred choice for ease of integration with WebDNA? I have not used Sybase, but I have used Pervasive and I couldn't recommend it at all. Pervasive was originally part of Netware and was spun off to its own product line. At the time, it was an embedded database (i.e. it was designed to be compiled directly into the application itself), so it was clearly not client-server. I don't know if they have changed that in the 5 years or so since I used it (with a financial package called Solomon). AFAIK, Pervasive is a shared access database (multiple processes can cooperatively access the database files) as opposed to a client-server (server process mediates access for multiple client processes). As far as what the marketing literature for PracticeWorks states, those are indeed the most common commercial client-server databases (they are excluding MySQL and PostgreSQL because they are not "commercial" but not because they are not client-server, which they both are). As I said, I have not used Sybase, but you are not going to be able to easily integrate it with WebDNA, since you are going to be limited to ODBC connections (only MySQL is supported natively by WebDNA). You should be sure that the Sybase application has good ODBC support and that you have access to the schema. Don't expect the vender to be all that much help trying to insert data into their databases... HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ John Peacock

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[WebDNA] eCommerce in 7.0 but not in 7.1? (2012) Looking up two prices in Formulas.db (1997) [WebDNA] Brian Harrington (2019) Document Contains no data, or showcart error. (1997) Username for Admin Group (1997) Apache on Windows (2005) OSX (2002) Not really WebCat (1997) Quick Question (1997) Question about searching combination of fields (2003) [PROTECT] Problem (2003) Protect vs Authenicate (1997) [WebDNA] Quick Date Question (2008) Shipping.db (1998) Re:listfiles-looking for slick solution (1997) To Do list (2003) [showif] question (2000) [table] question (2007) Webstar 1.3.1 PPC (1997) href name= link from dynamic URL possible? (1998)