Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Pro

 AfterLogic Forum : AfterLogic WebMail Pro
Subject Topic: How to use MDB with Webmail PHP 4.0? Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
arnor
Newbie
Newbie


Joined: 22 August 2007
Location: Taiwan
Online Status: Offline
Posts: 35
Posted: 16 October 2007 at 4:22am | IP Logged Quote arnor

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 View arnor's Profile Search for other posts by arnor
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 16 October 2007 at 4:39am | IP Logged Quote Andrew

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 View Andrew's Profile Search for other posts by Andrew
 
arnor
Newbie
Newbie


Joined: 22 August 2007
Location: Taiwan
Online Status: Offline
Posts: 35
Posted: 16 October 2007 at 6:11pm | IP Logged Quote arnor

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 View arnor's Profile Search for other posts by arnor
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 17 October 2007 at 1:02am | IP Logged Quote Andrew

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 View Andrew's Profile Search for other posts by Andrew
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide