Core Database integration
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38390
interpreted = N
texte = Hello WebCat meisters,I am looking for thoughts on the best way to integrate our Core Database and our WebCat db's. let me explain:We use a proprietary system made from Progress. This company makes a WebSpeed (ODBC compatible) module. However it can also produce a comma-deliminated text file and, more than likely, a tab-deliminated text file. We will integrate our customer info database as well as updating the inventory (or recording the sale) of our products.I can see two routes available to communicate with our Core Database. 1) through a tab-deliminated text file that interacts with a scheduler on both sides (such as triggers on the WebCat side). This system would entail picking up and creating text files in a central area. 2) using ODBC (sql) querys and such.I know very little currently of ODBC interaction and have some understanding of how I would approach the tab-deliminated file route. So this is my question...What approach has the most advantages? How would you approach this problem?Thanks much! -- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer GraphicsI know I'm making progress when I look at the questions I have asked in the past and think to myself... how stupid was that ------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hello WebCat meisters,I am looking for thoughts on the best way to integrate our Core Database and our WebCat db's. let me explain:We use a proprietary system made from Progress. This company makes a WebSpeed (ODBC compatible) module. However it can also produce a comma-deliminated text file and, more than likely, a tab-deliminated text file. We will integrate our customer info database as well as updating the inventory (or recording the sale) of our products.I can see two routes available to communicate with our Core Database. 1) through a tab-deliminated text file that interacts with a scheduler on both sides (such as triggers on the WebCat side). This system would entail picking up and creating text files in a central area. 2) using ODBC (sql) querys and such.I know very little currently of ODBC interaction and have some understanding of how I would approach the tab-deliminated file route. So this is my question...What approach has the most advantages? How would you approach this problem?Thanks much! -- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer GraphicsI know I'm making progress when I look at the questions I have asked in the past and think to myself... how stupid was that ------------------------------------------------------------- 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://search.smithmicro.com/
Donovan Brooke
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:
Can he do that? (1998)
test (2000)
5.0 tips etc (2003)
Setting up shop (1997)
Extended [ConvertChars] (1997)
WebDNA Solutions ... sorry! (1997)
PCS Emailer's role ? (1997)
Logging purchases (1997)
Categories (2000)
Potential Conflicts? (1997)
Mac v. NT (1998)
Submitting ampersands in forms... (1998)
form crasehes server (1997)
WebCat2: Master Counter snippet (1997)
Re:no template caching (1997)
PROBLEM (1997)
[isfile] ? (1997)
Protecting webdelivery (1997)
[WriteFile] problems (1997)
Hosts who have upgraded to v5.0? (2003)