Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sharing Act DB with Domain and Non-Domain Machines

New Member
Posts: 2
Country: USA

Sharing Act DB with Domain and Non-Domain Machines

Hello All...

OK.. I read a note almost like this BUT.. here's my issue..

Sage ACT! Pro 2011 Version 13.1.111.0, Hotfix 1

I have a shared DB on a Windows XP Pro PC connected to a domain.

I have several users that have domain accounts and have permission to connect and have been connecting fine.

We have two NON-domain machines attempting to 

 

After reading a couple of notes, I still cannot figure this out although I think I'm pretty close..

Here's the unedited PAD file that works for the domain-based clients.

_______________________________________________________________

<?xml version="1.0" standalone="no"?>
<!DOCTYPE ACTDatabasePADFile>
<!--This file represents a Pointer to an Act Database or [PAD]-->
<ACTDatabase name="NGKF_Office_DB" host="PORSPAREWXP-DT" location="C:\Documents and Settings\107473\My Documents\ACT\ACT Data\Databases\NGKF_Office_DB.ADF" type="Sql" />

_______________________________________________________________

 

I figure I can an edit this to reflect connecting via IP rather than "computer name", but I cannot figure the details out. I have the shared drive mapped on the non-domain system point directly to the folder that had the PAD file (see_mapped_drive).

mapped_drive_image.png

 

This is how I'm attempting to edit the PAD file on the non-domain machines.

The question is do I need to edit the "location=...." to match the mapped drive path or does that stay static?

_______________________________________________________________

<?xml version="1.0" standalone="no"?>
<!DOCTYPE ACTDatabasePADFile>
<!--This file represents a Pointer to an Act Database or [PAD]-->
<ACTDatabase name="NGKF_Office_DB" host="\\10.53.168.21" location="C:\Documents and Settings\107473\My Documents\ACT\ACT Data\Databases\NGKF_Office_DB.ADF" type="Sql" />

_______________________________________________________________

 

Any assistance would really help...

 

Thanks..

Nick

 

 

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Sharing Act DB with Domain and Non-Domain Machines

How many systems connectiong to the XP machine?

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 2
Country: USA

Re: Sharing Act DB with Domain and Non-Domain Machines

 

About six.. just three active users at one time..

The only reason for the machine was to serve up the DB.

There's a copy of office on the machine for minor overflow work.

 

very basic

Tuned Listener
Posts: 37
Country: USA

Re: Sharing Act DB with Domain and Non-Domain Machines

Nick,

 

You could certainly try the IP address for the HOST instead of the computer name. It would look like this:

<ACTDatabase name="NGKF_Office_DB" host="10.53.168.21" location="C:\Documents and Settings\107473\My Documents\ACT\ACT Data\Databases\NGKF_Office_DB.ADF" type="Sql" />

 

What error do you get? 

Have you tried turning off the Windows firewall (or other firewalls)?

I'd try opening up the ADF file directly and see what it says

Marshall Hayes
ACT! Certified Consultant
Hayes Consulting LLC
www.HayesConsultingOnline.com