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:
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:
New index for docs (1997)
problems with 2 tags shakur (1997)
Tab Charactor (1997)
Trigger alternatives please ... (2004)
NewCart+Search with one click ? (1997)
Conditional searching & displaying (1997)
Problem displaying search result (1997)
Incrementing a number (1998)
Different Drive (2003)
WebCat2 Append problem (B14Macacgi) (1997)
results in a table (2000)
WebTen and WebCat (1997)
absolute paths for databases? (1997)
Browser Problem?!? NN 4.0+ and Browser Info.txt? (1997)
NT - Thanks and Taxes (1997)
I can help! (1996)
Fun with Dates (syntax) (2002)
Dynamic Weather for my website - XML? (1999)
Location of Webcat site in folder hierarchy (1997)
[Price] (1997)