My company has developed several Web sites that are data driven. That is: almost all of the Web pages are generated dynamically, and a database influences which pages show up on the site, what's on the pages, and how the pages are laid out.
Currently our databases are all tab-delimited or comma-delimited ASCII files. Most of our code is written in C and VB6, and we use file-sharing flags judiciously to manage concurrency issues. In c we use the fread and fwrite functions to access the database files, and in VB6 we use FileSystemObject methods to access them. This has worked quite well, but we anticipate that the sites will be used more heavily in the near future, and we think it's time we started using a "real" database system because we want to make sure that concurrent access is not a problem. (Again, it has not been a problem up to this point, but we are concerned about scalability). I have several questions: 1. Does it make sense to consider using Microsoft Access for this? We'd like to use Access instead of SQL Server. 2. What is the best way to learn how to deal properly with concurrency issues so that we can avoid problems that could arise when several processes need to access the same database at the same time? 3. We've also thought about keeping the databases in their current formats and using something called the Microsoft Text Driver to read from them and write to them. Does anybody here have any experience doing this on a Web site? 4. How does ODBC technology fit into Web development? Again, our main reason for wanting to move to a "real" database system is a concern that our system will not handle contention properly if it is used heavily. Thanks. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
