No I dont think so.
I had seen that problem before - lets ask the list with this:
Hello everyone,
Carlos is trying to set up the ASP script which I sent him, and for some
reason IIS is saying:
[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
I had seen that problem before, but I dont remember the solution.
Imail operates fine with the Access database already, its just that the APS
script does not really want to work for him.
Does anybody know?
thanks,
Marcin
-----Original Message-----
From: Administrator [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 28, 1999 5:22 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Adding users via web.
Marcin,
I mapped the drive as you told me, but this is the message I got when I ran
the ASP:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
/exchange/USA/newaccts.asp, line 240
My IIS server is on another machine, I have my IMail alone (NT 4 SP5). My
ODBC driver is the default from NT.
Do you thing the IMail is locking my Access database?
Thanks,
Carlos Llanos
-----Original Message-----
From: Marcin Zastawny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 27, 1999 12:34 PM
To: Llanos Carlos
Subject: RE: Adding users via web.
First of all, make sure that You have an external database as your source of
user info.
Place this somewhere on your disk and set up an ODBC source (system) to it.
Lets say that you called the system dsn source IMAIL.
Lets say that You called this IMAIL.MDB, and you placed in in d:\database\
Lets also say that IMAIL is installed in d:\imail\ and that the user
directory is in d:\imail\users.
Lets say that your domain is called @mail.mydomain.com (with an alias to
@mydomain.com).
Make sure that the table that is in the Access database is called
MAIL_MYDOMAIN_COM
This is the first step.
Basically, you have to ensure that your imail is working with your database.
Add a few users, delete a few, and see them get added to the access table.
Likewise, add a user into the access table, and see him appear in the IMAIL
Administrator.
This must first work before you go ahead to automate this process.
Once this works, you would alter the beginning of that ASP script to
something like this:
Domain = "mail.mydomain.pl"
Alias = "mydomain.pl"
UserDir = "d:\imail\users"
IMailServerURL = "http://www.mydomain.com"
AccessMDB = "d:\database\imail.mdb"
SQLConnect="DSN=IMAIL"
Maxsize = 5242880
MaxMsgs = 1000
Flags = 128
AcctType = 0
Try this, if it does not work tell me and I will try to help you.
I must soon go home however (it is 21:30 in Poland ;-).
cheers,
Marcin
PS - I will be around for abother 30-60 minutes.
-----Original Message-----
From: Administrator [mailto:[EMAIL PROTECTED]]On Behalf Of
Llanos Carlos
Sent: Wednesday, October 27, 1999 9:19 PM
To: '[EMAIL PROTECTED]'
Subject: Adding users via web.
I tried your asp, it did not work. I am using a MS access database. Are
there any particular changes I have to do to make it work for my case?
Thank you very much for all your help.
Carlos Llanos
Systems Manager
Whittier College
562-907-4287
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
