Hi Tac,
At this stage all I've done is change the reference from 'hasread' to
'read' in data.cfm and it appears to be working fine, so fingers crossed
this might be the only fix required...
Many Thanx,
Brett
B)
Tac/Smokescreen Action Network wrote:
>
> I had this problem during one upgrade, it had to do with data.cfm using a
> SQL-Server database but being configured for a slightly different Access
> database.
>
> Someone volunteered to post the SQL to create the database -- I think that,
> and a blank Access database, could be part of a standard release of Fusion
> Mail.
>
> Tac
>
> >
> > >
> > >Information</H4><P>ODBC Error Code = 37000 (Syntax error or access
> > >violation)<P><P> [Microsoft][ODBC Microsoft Access 97 Driver] Syntax
> > >error in INSERT INTO statement.<P><P><p>The error occurred while
> > >processing an element with a general identifier of (CFQUERY), occupying
> > >document position (104:10) to (104:35).</p><P><P>Date/Time: 07/31/00
> > >11:24:57<BR>Browser: <BR>Remote Address:
> > >192.168.0.2<P></TD></TR></TABLE><P><HR>
> > >07/31/2000 11:24:57 [001] WARNING: </BODY></HTML>
> > >07/31/2000 11:24:57 [001] Moving mail file to orphans directory
> > >(0BF2F2CE9166D411B23600508BD92E27.mail)
> >
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.CoolFusion.com/iMS.htm
>
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
