Author |
|
Guests Guest Group
Joined: 10 November 2003
Online Status: Online Posts: 262
|
Posted: 18 January 2005 at 11:28am | IP Logged
|
|
|
The reinstall worked fine and now that I have the database settings configured I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXEC sp_tables wm_users, NULL, 'intersourcemail', 'TABLE'' at l
/functions_mailadm.inc.asp, line 688
Is there documentation for setting up the schema?
Thanks,
Tim
|
Back to Top |
|
|
Alex AfterLogic Support
Joined: 19 November 2003
Online Status: Offline Posts: 2206
|
Posted: 18 January 2005 at 12:16pm | IP Logged
|
|
|
It seems like MS SQL is specified as db server to use but MySQL settings are specified in the connection properties.
The code which produces error (functions_mailadm.inc.asp, line 688) should execute only if MS SQL mode is selected.
Try to do the following:
- restart IIS typing iisreset in Start\Run
- using notepad, open settings_values.inc.asp (it resides in 'data' folder of WebMail Pro installation, the path to 'data' folder itself is specified in web\settings_path.asp)
- check that Const globalIntDbType=1 (if not, set it to 1). "1" means MySql, "0" - MSSQL.
- save the file and close it
- go to WebMail admininistration and see whether it works now
Regards,
Alex
|
Back to Top |
|
|