Brightdayler
Search engine checker
 
Database Overview
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
Home/Set Up/Data
Menu for non Javascript users and search engines
All site Copyright © 1996-2005 PHD Computer Consultants Ltd, phdcc