Adding the stand alone to the primary domain should be no problem. All you have to do is change the workgroup to the domain name. As for Access not working. Try getting the new MDAC at www.microsoft.com/data . This may solve the connectivity problems you are having. Though I am using AQL 7 and it is a workhorse. I do tons of things on it and it works fine.

 

Bob Everland

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dave Wilson
Sent: Wednesday, February 02, 2000 8:07 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] Cannot Get External Access DB to work

 

Yes Bob,

 

I thought it should've worked too. Unfortunately, what the problem was (and still is unfortunately) that the Imail Server is a Primary Domain Controller for one domain and the CF server is a standalone on another domain, although both within same subnet (long story on that one). I'm considering moving the CF server onto the same domain as Imail, as even a scheduled cffile copy action (to copy db's from one machine to the other as a temp workaround) won't work.

 

I'd like to move everything onto SQL 7.0 but the developer we have working on the other aspects of the site is still only learning. Perhaps I'd best just wait til he has everything finished then migrate to SQL afterwards. I'm just impatient I guess :-)

 

By the way, you were right about getting it to work if Access db on same machine. I'll let you know if I can figure a workaround. Perhaps share the info on the CF-Talk list too, as there seems to be quite a few CF houses using Imail.

 

All the best,

 

Dave Wilson
Internet Technology Manager,
BizNet Solutions

 

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 -----

To: [EMAIL PROTECTED]

Sent: Thursday, February 03, 2000 12:46 AM

Subject: RE: [IMail Forum] Cannot Get External Access DB to work

 

Mapping like that should work I was thinking you were doing something else. How have you set up your database? You can e-mail me off the list with this if you want.

 

Bob

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dave Wilson
Sent: Wednesday, February 02, 2000 7:26 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] Cannot Get External Access DB to work

 

I've mapped a network drive path to the db from the Imail server to the CFserver....I also checked the Imail knowledgebase and there was an article stating it was possible.

 

I'll try placing the db on the local Imail machine to see if it works then.

 

Dave Wilson
Internet Technology Manager,
BizNet Solutions

 

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 -----

To: [EMAIL PROTECTED]

Sent: Thursday, February 03, 2000 12:15 AM

Subject: RE: [IMail Forum] Cannot Get External Access DB to work

 

Well unless you know a special way to install the Access database, Access databases can only be accessed on the machine it is on. If you want to have a database on a different machine you need to use SQL.

 

Bob Everland

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dave Wilson
Sent: Wednesday, February 02, 2000 6:36 PM
To: [EMAIL PROTECTED]
Subject: [IMail Forum] Cannot Get External Access DB to work

 

Hi all,

 

I've been trying in vain for a few hours to get the External database connection to work.

 

I've successfully set-up the System DSN in NT. The actual db is on another machine on our network which is also registered as a DSN of different name on that machine. The reason for this is that I am running ColdFusion on the other machine and am using the db for various aspects of a site. I am also intending to integrate automated creation of email accounts on member subscription to the web site.

 

I have ensured that connections are valid between machines and indeed I am able to add/update users in the external db using Imail administrator and vice versa.

 

The problem is that as soon as I try logging into the (testing123) account I have set up, using either web based access, or Microsoft Outlook Express, the username and password won't authorize so I can't receive any mail. Outgoing seems to be fine as this is simply smtp.

 

I would be very grateful if someone could help as we would like this up and running asap.

 

Regards,

Dave

 

Dave Wilson
Internet Technology Manager,
BizNet Solutions

 

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]

Reply via email to