Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic MailSuite

 AfterLogic Forum : AfterLogic MailSuite
Subject Topic: Database connection problems Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
tnm
Newbie
Newbie
Avatar

Joined: 06 November 2010
Location: Zimbabwe
Online Status: Offline
Posts: 1
Posted: 06 November 2010 at 11:52am | IP Logged Quote tnm

Is anyone facing difficulties connecting to the databases in the Webmail>Database settings section of the admin panel?

I'm running MySQL on the same server. I am positive I used the correct connection settings because I tried them in the mysql console and they worked. Whenever I click 'Test connection' is just returns the message 'Connect unsuccessful!'

I've also tried using MS Access. It connects easily to the database. But when I try to add a user to a domain I get the following error:

Syntax error (missing operator) in query expression 'awm_accounts.id_user = awm_settings.id_user INNER JOIN a_users ON awm_accounts.id_user = a_users.id_user'.

This is my setup. Windows XP, MySQL 5.1.36, MailSuite Pro for Windows with free perpetual license.

Please help!!!!
Back to Top View tnm's Profile Search for other posts by tnm
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6044
Posted: 07 November 2010 at 2:12am | IP Logged Quote Igor

To access MySQL from ASP.NET application, you'll need ODBC Connector installed. There's version 5.1 also available but still we suggest using 3.51.

Hope this helps!

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 

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