I know access blows, but for the current time we only have
spent around $15000 in SQL 7 licencing and don't really care
to spend any more...and we will NOT share an existing server
to accomplish this. IMail + ODBC functionality is still on
our "Test List" as far as we're concerned.
As for concurrent accessing, i would suprised if it couldn't
handle two connections. It's more like the combination between
the IMail web access is not removing a lock on the database
or the OS not invalidating the lock...because the same
functionality works fine under the console admin.
We eventually will move it to mssql, but for the
time being i need to prototype on the access db. I've downloaded
and looked through the DLL source, and didn't see any string
constants which remotely match..so it's either the IMail web
binary, or Access returning the code.
Regardless if using access is a good idea or not (which it
isn't), someone must have seen this before, or heard of a workaround.
Franco Gasperino
Webiness
----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Len Conrad
Sent: Wednesday, September 27, 2000 1:50 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] Two Questions from a newbie IMail Admin...
Hi Franco
>We have two issues with IMail 6.0 we're working on. Pardon my inexperience
>here
>since I'm a Unix guy. The basic services seem to work well, and we selected
>IMail
>because of the ODBC-compliant authentication and session ability.
Even Unix people must have heard the Access is a desktop application
with sucky locking and reliabilty, totally unsuitable high rates of
simultaneous access by even just 10 users, which isn't many compared
to mailservers with 100's or 1000's of user accounts.
> From what i've been told, this is an access lock problem.
hmm, is there an echo in here? vbg
>I've verified that the DSN is not setup to use exclusive access,
but that doesn't remove all, or any, locking requirements.
Access will only be useable if you have very low rates of
simultaneous access, noting that Imail needs access for LDAP/pop3
logins, SMTP AUTH, web messaging logins, at least.
You didn't mention how many mail accounts you have or plan to have,
but Access is probably going to cost you a lot more than what you
saved not going with SQL Server.
But SQL is expensive for Internet usage. I think some people on the
this list have gotten Imail working into odbc/MySQL, ( personally
would like to see a how-to for Imail + Postgres).
Len
http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5 installable binary for NT4
http://IMGate.MEIway.com: Build free, hi-perf, anti-spam mail gateways
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
