I installed the latest EmerAuth.DLL on my IMail 6.02 machine and configured
Imail to to use the DLL.
I configured EmerAuth to use a DSN that points to the Emerald database in
SQL Server 6.5 (w/ SP5a), but I get the following errors :
Feb 05 00:19:42 2000 GetUserEntry root
Feb 05 00:19:42 2000 IMailGetUser IMailUsers
0,'root','joshua.uplink.com.ph'
Feb 05 00:19:42 2000 IMailGetUser [Microsoft][ODBC SQL Server
Driver][SQL Server]Stored procedure 'IMailUsers' not found. [IMailUsers
0,'root','joshua.uplink.com.ph']
Feb 05 00:19:42 2000 SetUserEntry IMailSetUser 'root',
'joshua.uplink.com.ph', 'password', 0, 0, 0, 7
Feb 05 00:19:42 2000 SetUserEntry [Microsoft][ODBC SQL Server
Driver][SQL Server]Stored procedure 'IMailSetUser' not found. [IMailSetUser
'root', 'joshua.uplink.com.ph', 'password', 0, 0, 0, 7]
So I renamed the "VerifyImailUser" stored procedure to "IMailUsers" (using
SQL Enterprise Manager), then I got the following errors :
Feb 05 00:24:00 2000 GetUserEntry root
Feb 05 00:24:00 2000 IMailGetUser IMailUsers
0,'root','joshua.uplink.com.ph'
Feb 05 00:24:00 2000 IMailGetUser [Microsoft][ODBC SQL Server
Driver][SQL Server]Implicit conversion from datatype 'int' to 'varchar' is
not allowed. Use the CONVERT function to run this query. [IMailUsers
0,'root','joshua.uplink.com.ph']
Feb 05 00:24:00 2000 SetUserEntry IMailSetUser 'root',
'joshua.uplink.com.ph', 'password', 0, 0, 0, 7
Feb 05 00:24:00 2000 SetUserEntry [Microsoft][ODBC SQL Server
Driver][SQL Server]Stored procedure 'IMailSetUser' not found. [IMailSetUser
'root', 'joshua.uplink.com.ph', 'password', 0, 0, 0, 7]
What do I need to do to fix these problems ?
- Danny
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart