Click here to Skip to main content
Click here to Skip to main content
 
Add your own
alternative version

Using a Wiki for knowledge sharing and SQL Server database documentation

, 7 Feb 2004
This article describes using a Wiki for knowledge sharing and database schema documentation.
wiki_src.zip
attachments
images
Help
edit_comment.gif
Thumbs.db
Wiki
DatabaseSchema.gif
DeprecatedBanner.gif
FindPage.gif
HelpBanner.gif
Key.gif
NoTick.gif
Thumbs.db
Tick.gif
UserPreferences.gif
ow
css
images
banner_logo.gif
banner_search.gif
banner_title.gif
breadcrumb_divider.gif
dashed_line.gif
delico.gif
edit_icon.gif
find_icon.gif
grey_box_left.gif
grey_box_line.gif
grey_box_right.gif
hidden_off.gif
hidden_on.gif
icons
doc
asp.gif
avi.gif
bmp.gif
chm.gif
doc.gif
empty.gif
gif.gif
gz.gif
htm.gif
html.gif
jpeg.gif
jpg.gif
mov.gif
mp3.gif
mpeg.gif
mpg.gif
pdf.gif
png.gif
ppt.gif
Thumbs.db
txt.gif
wav.gif
xls.gif
xml.gif
xsl.gif
zip.gif
emoticon-8.gif
emoticon-ambivalent.gif
emoticon-b.gif
emoticon-c.gif
emoticon-cat.gif
emoticon-d.gif
emoticon-e.gif
emoticon-f.gif
emoticon-g.gif
emoticon-h.gif
emoticon-i.gif
emoticon-k.gif
emoticon-l.gif
emoticon-laugh.gif
emoticon-m.gif
emoticon-n.gif
emoticon-p.gif
emoticon-s.gif
emoticon-sad.gif
emoticon-smile.gif
emoticon-star.gif
emoticon-surprised.gif
emoticon-t.gif
emoticon-tongue-in-cheek.gif
emoticon-u.gif
emoticon-unsure.gif
emoticon-wink.gif
emoticon-wink_old.gif
emoticon-y.gif
icon-error.gif
icon-info.gif
icon-warning.gif
Thumbs.db
wiki-ftp.gif
wiki-http.gif
wiki-mailto.gif
wiki-news.gif
wiki-telnet.gif
wiki-wiki.gif
icon_edit.gif
icon_print.gif
icon_revisions.gif
logo.gif
logo_aggregator.gif
logo_tiny.gif
popup.gif
popup2.gif
poweredby.gif
revs.gif
rss_button.gif
Thumbs.db
undo.gif
valid-css.gif
valid-xhtml10.gif
xml.gif
my
xsl
mystyle.xsl
ow.xsl
owattach.xsl
owinc.xsl
owrss09.xsl
owrss091.xsl
owrss10.xsl
owrss10aggr.xsl
owrss10export.xsl
owscriptingnews.xsl
xmldisplay.xsl
data
wiki.mdb
wikidb.mdf
<%

' Following are all the configuration items with default values set.
' Override them if you want in a separate file, see e.g. /web1/ow.asp.

' "The Truth about MS Access" : http://www.15seconds.com/Issue/010514.htm
' OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\data\openwiki\OpenWiki.mdb"
' OPENWIKI_DB = "Driver={SQL Server};server=mymachine;uid=openwiki;pwd=openwiki;database=OpenWiki"
' OPENWIKI_DB = "Driver={Microsoft ODBC for Oracle};Server=OW;Uid=laurens;Pwd=aphex2twin;"
' OPENWIKI_DB = "MySystemDSName"
' OPENWIKI_DB = "MySQLOpenWiki"
' OPENWIKI_DB = "PostgreSQLOpenWiki"
' OPENWIKI_DB = "OpenWikiDist"

'OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\wiki\data\Wiki.mdb"
'OPENWIKI_DB_SYNTAX = DB_ACCESS

OPENWIKI_DB = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=wiki;Data Source=(local)"
OPENWIKI_DB_SYNTAX = DB_SQLSERVER               ' see owpreamble.asp for possible values

OPENWIKI_IMAGEPATH       = "ow/images"        ' path to images directory
OPENWIKI_ICONPATH        = "ow/images/icons"  ' path to icons directory
OPENWIKI_ENCODING        = "ISO-8859-1"       ' character encoding to use
OPENWIKI_TITLE           = "Project Title"          ' title of your wiki
OPENWIKI_FRONTPAGE       = "Home"             ' name of your front page.
OPENWIKI_SCRIPTNAME      = "ow.asp"           ' "mydir/ow.asp" : in case the auto-detected scriptname isn't correct
OPENWIKI_STYLESHEETS     = "ow/xsl/"          ' the subdirectory where the stylesheet files (*.xsl) are located
OPENWIKI_MAXTEXT         = 204800             ' Maximum 200K texts
OPENWIKI_MAXINCLUDELEVEL = 5                  ' Maximum depth of Include's
OPENWIKI_RCNAME          = "RecentChanges"    ' Name of recent changes page (change space to _)
OPENWIKI_RCDAYS          = 30                 ' Default number of RecentChanges days
OPENWIKI_MAXTRAIL        = 5                  ' Maximum number of links in the trail
OPENWIKI_STOPWORDS       = "StopWords"        ' Name of page containing stop words (change space to _). Stop words are words that won't be hyperlinked. Use empty string "" if you do not want to support stop words.
OPENWIKI_TEMPLATES       = "Template$"        ' Pattern for templates usable when creating a new page
OPENWIKI_TIMEZONE        = "+00:00"           ' Timezone of the server running this wiki, valid values are e.g. "+04:00", "-09:00", etc.
OPENWIKI_MAXNROFAGGR     = 150                ' Maximum number of rows to show in an aggregated feed
OPENWIKI_MAXWEBGETS      = 3                  ' Maximum number of RSS feeds that may be refreshed from a remote server for one user request.
OPENWIKI_SCRIPTTIMEOUT   = 120                ' Maximum amount of seconds to wait for RSS feeds to be syndicated, if set to 0 the default timeout value of ASP is used.
OPENWIKI_DAYSTOKEEP      = 30                 ' Number of days to keep old revisions
OPENWIKI_UPLOADDIR       = "attachments/"     ' The virtual directory where uploads are stored
OPENWIKI_MAXUPLOADSIZE   = 8388608            ' Use to limit the size of uploads, in bytes (default = 8,388,608)
OPENWIKI_UPLOADTIMEOUT   = 300                ' Timeout in seconds (upload must succeed within this time limit)


MSXML_VERSION = 3   ' use 4 if you've installed MSXML v4.0

gReadPassword = ""    ' use empty string "" if anyone may read
gEditPassword = ""    ' use empty string "" if anyone may edit
' In case you want more sophisticated security, then you should
' rely on the Integrated Windows authentication feature of IIS.

gDefaultBookmarks = "Home RecentChanges FindPage TitleIndex SandBox UserPreferences Help"

' Major system options
cReadOnly             = 0        ' 1 = readonly wiki         0 = editable wiki
cNakedView            = 0        ' 1 = run in naked mode     0 = show headers/footers
cUseSubpage           = 1        ' 1 = use /subpages         0 = do not use /subpages
cFreeLinks            = 1        ' 1 = use [[word]] links    0 = LinkPattern only
cWikiLinks            = 1        ' 1 = use LinkPattern       0 = possibly allow [[word]] only
cAcronymLinks         = 0        ' 1 = link acronyms         0 = do not link 3 or more capitalized characters
cTemplateLinking      = 1        ' 1 = allow TemplateName->WikiLink   0 = don't do template linking
cRawHtml              = 0        ' 1 = allow <html> tag      0 = no raw HTML in pages
cMathML               = 0        ' 1 = allow <math> tag      0 = no raw math in pages
cHtmlTags             = 0        ' 1 = "unsafe" HTML tags    0 = only minimal tags
cCacheXSL             = 0        ' 1 = cache stylesheet      0 = don't cache stylesheet
cCacheXML             = 0        ' 1 = cache partial results 0 = do not cache partial results
cAllowRSSExport       = 1        ' 1 = allow RSS feed        0 = do not export your pages to RSS
cAllowNewSyndications = 1        ' 1 = allow new URLs to be syndicated    0 = only allow syndication of the URLs in the database table openwiki_rss
cAllowAggregations    = 1        ' 1 = allow aggregation of syndications (note: you MUST use MSXML v3 sp2 for this to work)   0 = do not allow aggregrations
cEmbeddedMode         = 0        ' 1 = embed the wiki into another app    0 = process browser request
cAllowAttachments     = 0        ' 1 = allow attachments     0 = do not allow attachments (WARNING: Allowing attachments poses a security risk!! See file owattach.asp)

' Minor system options
cSimpleLinks          = 1        ' 1 = only letters,         0 = allow _ and numbers
cNonEnglish           = 1        ' 1 = extra link chars,     0 = only A-Za-z chars
cNetworkFile          = 0        ' 1 = allow remote file:    0 = no file:// links
cBracketText          = 1        ' 1 = allow [URL text]      0 = no link descriptions
cBracketIndex         = 1        ' 1 = [URL] -> [<index>]    0 = [URL] -> [URL]
cHtmlLinks            = 1        ' 1 = allow A HREF links    0 = no raw HTML links
cBracketWiki          = 1        ' 1 = [WikiLnk txt] link    0 = no local descriptions
cShowBrackets         = 0        ' 1 = keep brackets         0 = remove brackets when it's an external link
cFreeUpper            = 1        ' 1 = force upper case      0 = do not force case for free links
cLinkImages           = 1        ' 1 = display image         0 = display link to image
cUseHeadings          = 1        ' 1 = allow = h1 text =     0 = no header formatting
cUseLookup            = 1        ' 1 = lookup host names     0 = skip lookup (IP only)
cStripNTDomain        = 1        ' 1 = strip NT domainname   0 = keep NT domainname in remote username
cMaskIPAddress        = 0        ' 1 = mask last part of IP  0 = show full IP address in RecentChanges list, etc.
cOldSkool             = 1        ' 1 = use '' and '''        0 = don't use '' and ''' for italic and bold, and use Wiki''''''Link to escape WikiLink
cNewSkool             = 1        ' 1 = use //, **, -- and __ 0 = don't use //, **, -- and __ for italic, bold, strikethrough and underline and use ~WikiLink to escape WikiLink
cNumTOC               = 0        ' 1 = TOC numbered          0 = TOC just indented text
cNTAuthentication     = 1        ' 1 = Use NT username       0 = blank username in preferences
cDirectEdit           = 0        ' 1 = go direct to edit     0 = go to blank page first
cAllowCharRefs        = 1        ' 1 = allow char refs       0 = no character references allowed (like &copy; or &#151;)
cWikifyHeaders        = 0        ' 1 = wikify headers        0 = do not apply wiki formatting within headers

' User options
cEmoticons            = 1        ' 1 = use emoticons         0 = don't show feelings
cUseLinkIcons         = 0        ' 1 = icons for ext links   0 = no icon images for external links
cPrettyLinks          = 1        ' 1 = display Words Smashed Together     0 = display WordsSmashedTogether
cExternalOut          = 1        ' 1 = external links open in new window, 0 = open in same window

%>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Jonathan Hodgson
Web Developer
United Kingdom United Kingdom
Jonathan Hodgson works as Software Developer in London, UK.
 
He started programming in the '80s on a trusty 48k Spectrum before moving to PC development in the early 90s. During the working week most of his time is spent involved in application development both Windows and Web-based; .NET, C#, ASP.NET, SQL Server.
 
He is a Microsoft Certified Software Developer (MCSD) and MCP for developing web applications using ASP.NET in C# and is always looking for new projects and challenges to work on.
 
http://www.jonathanhodgson.co.uk/

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141223.1 | Last Updated 8 Feb 2004
Article Copyright 2004 by Jonathan Hodgson
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid