For Brightdayler to work it needs to read and write data from a database. It uses SQL commands to do this so it can
be integrated with pretty well anything that uses standard SQL syntax. The connection string for the database is read from
dbconn.txt situated in the application root directory. (There are examples of alternatives in dbclist.txt which
you can cut, paste and edit to dbconn.txt).
In general, if you are running Brightdayler on a shared web server you will have to use whatever database administration system
is available to you as administrator. You will then need to edit the dbconn.txt file so that the Server, Database, User
and Password all correspond.
If you are running Brightdayler from a local machine you might need to set up a database application. See the different items
on this page.
Once the database is running you will need to run mydbcreator.aspx, msdbcreator.aspx, acdbcreator.aspx etc
to create and populate the tables.
Some example database connection strings:
MySQL on PC
DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=phd1;UID=phd1;PASSWORD=secret;OPTION=3
MySQL on Web Server
DRIVER={MySQL ODBC 3.51 Driver};SERVER=MySQL1.webcontrolcenter.com;DATABASE=phd1;UID=phd1;PASSWORD=secret;OPTION=3
MS SQL Server
DRIVER={SQL Server};SERVER=SQLA24.webcontrolcenter.com;DATABASE=phd1;UID=phd1;PWD=secret
Access, use %MAP_PATH% to make brightdayler substitute the physical path to the application root
ie D:\inetpub\domaintest1234\brightdayler\ or get the physical path from your control panel and enter it in the string
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%MAP_PATH%database\phd1.mdb
Access
DRIVER={Microsoft Access Driver (*.mdb)};DBQ=database/phd1.mdb