Found a solution!!!!
Make an Access database with tables that just link to external tables on
MSSQL database.
Point IMail at dsn for access database, and it all gets translated with no
threading error...
----- Original Message -----
From: Wayne Maw <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; David Karp <[EMAIL PROTECTED]>
Sent: 22 June 1999 13:28
Subject: [IMail Forum] Sql problem
> We have been having user passwords refused (when they are correct), with
> imail5.04 and sql server6.5
>
> After tracing odbc link
>
> I find:
> ;-----------------------------------
> POP3D32 131:1a1 ENTER SQLExecDirect
> HSTMT 0x00562e68
> UCHAR * 0x0150d0fc [ -3] "SELECT * FROM
> smtp_callnetuk_com WHERE USERID = 'lee0'\ 0"
> SDWORD -3
>
> POP3D32 131:1a1 EXIT SQLExecDirect with return code -1
(SQL_ERROR)
> HSTMT 0x00562e68
> UCHAR * 0x0150d0fc [ -3] "SELECT * FROM
> smtp_callnetuk_com WHERE USERID = 'lee0'\ 0"
> SDWORD -3
>
> DIAG [S1000] [Microsoft][ODBC SQL Server Driver]Connection is busy with
> results for another hstmt (0)
>
> DIAG [S1000] [Microsoft][ODBC SQL Server Driver]Connection is busy with
> results for another hstmt (0)
> ;---------------------------------------
>
> Now according to MS knowledge base:
>
> http://support.microsoft.com/support/kb/articles/q175/9/04.asp
>
>
> ;----------------------------------
>
> Anybody know a fix for this.
>
>
>
>
>
>
>
>
