Author |
|
arnor Newbie

Joined: 22 August 2007 Location: Taiwan
Online Status: Offline Posts: 35
|
Posted: 16 October 2007 at 4:22am | IP Logged
|
|
|
I want to try to use mdb (microsoft access db) to be database for webmail php pro 4.0.
I can setup mdb path to do test connection in mailadm, but I can't create account in database.
What should I do about this mdb file?
mailadm didn't create table for access mdb?
(because there is a "create tables" button for mysql option but mdb doesn't have this button enabled)
|
Back to Top |
|
|
Andrew AfterLogic Support

Joined: 28 April 2006 Location: United States
Online Status: Offline Posts: 1189
|
Posted: 16 October 2007 at 4:39am | IP Logged
|
|
|
MS Access database is not supported yet, but we're implementing its support now. "MS Access" option in the database configuration is reserved for future use. This feature will become available in WebMail Pro 4.1 which will be released less than in a month.
However, MS SQL Server and MySQL are fully supported in the current version.
Best regards,
Andrew
|
Back to Top |
|
|
arnor Newbie

Joined: 22 August 2007 Location: Taiwan
Online Status: Offline Posts: 35
|
Posted: 16 October 2007 at 6:11pm | IP Logged
|
|
|
How to use MSSQL?
check MSSQL option and then?
because I don't see any config about MSSQL.
ODBC connection string is for MSSQL?
|
Back to Top |
|
|
Andrew AfterLogic Support

Joined: 28 April 2006 Location: United States
Online Status: Offline Posts: 1189
|
Posted: 17 October 2007 at 1:02am | IP Logged
|
|
|
If you have MS SQL Server installed, you should create a database for WebMail Pro, or you may use any of existing ones and there shouldn't be name conflicts because WebMail Pro uses special prefix for table names.
Once you have a database and a database user which has full access over the created database, you should specify the following data in WebMail Pro database configuration:
DB type: MS SQL server
SQL login: [username which have access to webmail database]
SQL password: [password of the database user]
Database name: [name of the database you created]
Data source (DSN): [create a DSN for WebMail Pro database or use hostname instead]
Host: [if you didn't create a DSN, you may specify hostname or IP address of the host MS SQL Server installed on]
Then click "Save", then "Test Connection" and "Create Tables". That's all.
You can learn more from WebMail Pro 4 documentation.
Best regards,
Andrew
|
Back to Top |
|
|