Configuration of databases
AdMentor uses a pluggable and highly configurable infrastructure to ensure maximal performance against different types of databases, it comes with drivers against MS SQL Server 2000 or higher, MySQL 4 or less, MySQL 5 or higher.
Microsoft SQL Server
Have a database created in SQL Server (for simplicity here lets call it SqlAdMentor). Run the script SQLServer.txt which is available in the /sqlscripts/ directory.
Modify web.config like this:
<add key="ConnString" value="Server=(local);Database=SqlAdMentor;Trusted_Connection=False;uid=theuser;pwd=thepassword;" />
<add key="DataAccessComponent"
value="DataAccessSQL.DataAccess, DataAccessSQL" />
Of course you need to put in your own values for server/uid/pwd.
The install script creates the first admin user – login as admin with password aspcode the first time.
MySQL 4 or less (no stored procedure support)
Have a database created in MySQL (for simplicity here lets call it MyAdMentor). Run the script MySQL4.sql which is available in the /sqlscripts/ directory. Note that depending on which query tool you use you might need to add this line:
use myadmentor;
in the top of the file – or whatever database name you are using.
Modify web.config like this:
<add key="ConnString"
value=" Database=myadmentor;Data Source=localhost;User id=root;Password=stefan" />
<add key="DataAccessComponent" value="DataAccessMySQL5.DataAccess, DataAccessMySQL5" />
<add key="UseSP" value="0" />
Of course you need to put in your own values for Data source/user id/password.
The install script creates some sample users and campaigns – login as admin with password aspcode the first time.
MySQL 5 or higher (with stored procedure support)
Same as for MySQL 4 but with this difference:
<add key="UseSP" value="1" />
The install script creates some sample users and campaigns – login as admin with password aspcode the first time.
Postgresql
This driver is scheduled to be released in middle of May 2007.