All Forums  MOHICAN BOARD COURIER  The New Deal!  New Database Format

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Format Mode: Basic  Help  Prompt  Format: Videos: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message Icon:                             Message: Smilies [quote][i]Originally posted by richfed[/i] [br]Yesterday, we upgraded the Mohican Board enabling it to utilize a MS SQL database rather than the MS Access 2000 database we had been using. The Board needed to be shut down while the data was converted to avoid loosing any posts made in the interim. For those who care - the old Mohican Board simply created HTML pages for each post, in effect a web page. When we switched to Snitz Forums in May '02, a database was utilized to store - and then call - all information. That's what A[ctive] S[erver] P[ages] does. It is a software system - in this case a board - that is interactive with the server & retrieves data as necessary. Anyway, we were using Access, which any of you who use Microsoft Office are probably familiar with. Same thing. Access works fine, but has its limitations as the database grows. Thus, though not needed at this point, we switched to SQL - which I think stands for Server Query Language, or something like that. It would have been inevitable. This database will allow the Board to grow without performance loss. So they say ... All functionality should remain the same, if it works at all. Some of the code is written specifically for Access which is why I anticipated a glitch or two, but so far all seems well to my eye. Again, if something seems out of whack to you, do let us know right away. The big test remaining is will it allow folks to register? If no new members appear in a day or two, I'll run a test registration over the weekend sometime. And there you have it, the boring post of the week! [/quote]    Upload an Image File From Your PC For Insertion in Your Post    -  HTML is OFF | Forum Code is ON   Check here to include your profile signature.