Sorted the problem out myself.
As I had imported the original Access table as a comma delimited text file,
then set the datatypes for each field manually it turned out that I had one
of the fields set wrongly. I discovered this by letting Imail create a new
table within the db and compared the field datatypes.
Regards,
Dave Wilson
Internet Technology Manager,
BizNet Solutions
<Allaire Premier Partner>
Co-Founder CFUG Ireland
http://www.cfug.ie
224, Lisburn Road
Belfast BT9 6GE
Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com
email: [EMAIL PROTECTED]
----- Original Message -----
From: Dave Wilson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 27, 2000 9:22 PM
Subject: [IMail Forum] External db's - Revisited
> Hi all,
>
> I'd been using an External Access db for one of my Virtual domains with
> Imail without problems for some time now. I then decided to upsize my db
to
> SQL 7.0 (at last) today.
>
> This process proved relatively painless until I realized that Imail was no
> longer creating user directories when adding a new user to the db via my
> ColdFusion membership sign-up application (which worked perfectly with
> Access).
>
> I think I've tried every possibility known to remedy this problem without
> luck, so if anyone can think of anything other than what is listed below,
> please let me know as I need this up and running again pretty urgently.
>
> By the way, everything works except for the directory creation i.e. users
> adding and deleting perfectly from all interfaces (web/Imail admin/db).
>
> Set UID and PWD (also set DB) within Imail administrator.
> Setup ODBC connection using tcp/ip within NT ODBC admin
> Tried sending mail to each user account (got undeliverable messages
returned
> in their hundreds)
> Imail services using Administrator account, which also has access to the
> SQL7.0 db in question
>
> Thanks in advance
> Dave
>
> Dave Wilson
> Internet Technology Manager,
> BizNet Solutions
>
> <Allaire Premier Partner>
> Co-Founder CFUG Ireland
> http://www.cfug.ie
>
> 224, Lisburn Road
> Belfast BT9 6GE
>
> Tel: 02890 225 776
> Fax: 02890 223 223
> web: http://www.biznet-solutions.com
>
> email: [EMAIL PROTECTED]
>
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
