ACT!
Register  ·  Sign In  ·  Help
Jump to Page:   1 · 2 · 3  |  Next Page
  Reply   Reply  

Re: Unable to connect to server database
Options    Options  
Moderator ghollister Moderator
Moderator
Posts: 1705


ghollister

Country: USA

Message 11 of 21

Viewed 2,339 times


Is there an error when ACT! shuts down? Such as "The application has encountered a problem..."? This sounds like it may be Microsoft .NET Framework error.
 

Greig Hollister
Moderator
ACT! Online Community
Sage

Kudos!
07-31-2009 06:02 AM
 
  Reply   Reply  

Re: Unable to connect to server database
Options    Options  
mike449
Copper Contributor
Posts: 10


mike449

Country: United States

Message 12 of 21

Viewed 2,559 times


No error at all. Just the splash screen followed by the main ACT! screen that only shows for about a second or less.

 

Kudos!
07-31-2009 10:59 AM
 
  Reply   Reply  

Re: Unable to connect to server database
Options    Options  
Moderator ghollister Moderator
Moderator
Posts: 1705


ghollister

Country: USA

Message 13 of 21

Viewed 2,550 times


A possible cause for this could be conflicting assemblies. Do this:

- From Windows Explorer, browse to C:\Windows\assembly

- In the assembly folder, sort the list by version

- The ACT! 2006 assemblies should begin with 8...look for any assemblies that are a different version than the majority of the assemblies (ie, 8.0.1 instead of 8.0.2). Delete these odd assemblies by right-clicking on them and choosing "Uninstall"

- When done, try and open ACT!


 

Greig Hollister
Moderator
ACT! Online Community
Sage

Kudos!
07-31-2009 12:38 PM
 
  Reply   Reply  

Re: Unable to connect to server database
Options    Options  
dshaw111
Copper Super Contributor
Posts: 35


dshaw111

Country: United Kingdom

Message 14 of 21

Viewed 2,532 times


Mike449,

 

Your problem seems to have now taken you 10 days since you first raised it on this forum.  This would probably have been resolved on the first day if you had had an ACT! Certified Consultant on site.  Although this would have been at a cost, I'm sure it would have been less than the cost you have had to bear in time and effort.

 

My question to you and all similar users who have problems during installation is why try and do it 'on the cheap'?  It's a false economy!  And a consultant would have shown you so much more on the day with lots of practical advice etc..

 

My 2 cents worth - not as a criticism but an attempt to help you and others realise the enormous value an ACT! consultant brings with them.

 


 

With kind regards,

David Shaw
ACT! Certified Consultant
Office:    +44 (0)8443 571 222
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org 
Kudos!
08-01-2009 02:09 AM
 
  Reply   Reply  

Re: Unable to connect to server database
Options    Options  
mike449
Copper Contributor
Posts: 10


mike449

Country: United States

Message 15 of 21

Viewed 2,512 times


Uninstalling ACT! (yet again) and removing the ACT-specific files in the \assembly directory did the trick. I can now run ACT! again from the server. I am still not able to access the database from any other pc on the office network. I can, however, create, delete, and edit files using notepad in the ACT! database directories. Any other ideas?
Kudos!
08-01-2009 12:40 PM
 
  Reply   Reply  

Re: Unable to connect to server database
Options    Options  
mike449
Copper Contributor
Posts: 10


mike449

Country: United States

Message 16 of 21

Viewed 2,515 times


Well, David what you say is probably correct in that an expert in the installation and operation of ACT! could have fixed this problem fairly quickly. On the other hand, a simple installation and evaluation of a product to be used in a 4 person office should not require said 'expert'. If a product is this difficult to set up by an experienced user, then its utiltiy to a greater population is surely handycapped.

Thanks for the interest and reply,

Mike

Kudos!
08-01-2009 12:47 PM
 
  Reply   Reply  

Re: Unable to connect to server database
Options    Options  
Nickel Contributor gleo
Nickel Contributor
Posts: 329


gleo

Country: New Zealand

Message 17 of 21

Viewed 2,490 times


Installation of ACT! on a PC in a non-networked situation on a machine of good specification and condition, that is not 'tainted' by earlier versions of ACT!, has a good chance of successful install. It appears that your installation had a prior version or perhaps you had upgraded with an inline release of ACT! 2006.

In our experience in the days of ACT! 2006 installation we found it important to do a complete uninstall of any prior versions rather than an inplace upgrade. Success rate was substantially better. Additionaly stopping any antivirus software was important.

 

When you add in the complexity of sharing, permissions and firewall issues of networks the chances of problems are increased. Whether it is a 4 person office or a 20 person office the risks are the same, even perhaps more so if the 4 person office doesn't have a server but relies on the flakiness of a peer to peer network which appears to be the case here. There can be multiple causes of a problem so discerning network issues, from SQL issues from .Net issues from permissions and rights issues etc is learned from experience. I suggest that is what David is pointing out.   

 

After doing many installs of ACT! in commercial offices large and small, I can say based on experience that the problems are more often than not related to networks, SQL, .Net 1.0,  prior instances of ACT!, and undespecified or poorly maintained machines. Unfortunately software companies are solely dependent on selling licences not successful installs, wheras the ACT Consultant is interested in a successful outcome for the client both from a technical and a business perspective, i.e. ACT! customised to fit the business need.

 

So Sage marketing are somewhat hesitiant in boldly advising people that perhaps they should engage an experienced consultant when embarking on a project involving a network.      


 

Graeme Leo
Xact Software Solutions
Auckland, New Zealand
International ACT! Certified Consultant (IACC) and ACT! Custom Developments
graeme@xactsoftware.co.nz
Kudos!
08-01-2009 09:25 PM
 
  Reply   Reply  

Re: Unable to connect to server databse
Options    Options  
mike449
Copper Contributor
Posts: 10


mike449

Country: United States

Message 18 of 21

Viewed 2,471 times


Thanks Graeme for your comments.

 

The situation:

1. ACT! was originally installed on a purpose-built PC running a new fresh copy of XP with the current service packs.

2. Client PC's (2 of them) had sucessfull installations of ACT! and are able to use their local demo database without issues.

3. Clients are able to create, read, and write to files in the ACT! directories on the server.

4. Clients cannot access the ACT! demo database on the server.

5. ACT! on the server is able to access and modify its own local demo database and the company database.

6. I still receive the error message: "The databse PFM_2 could not be accessed. In order to access the database, check your network connection and verify that your database server is available."

 

Thanks, Mike

Kudos!
08-02-2009 06:58 AM
 
  Reply   Reply  

Re: Unable to connect to server databse
Options    Options  
Nickel Contributor gleo
Nickel Contributor
Posts: 329


gleo

Country: New Zealand

Message 19 of 21

Viewed 2,453 times


Some things to check:

Firewall setup: Go through Document ID 19420  and check that the Windows firewall on the 'server' conforms with these settings

Pad File:  Can you open the pad file that you access from the client that gives you the error message, and copy the contents here. Right click, Open with Notepad and Copy & Paste.

Network: Are you running IP addresses? Can you browse the Internet OK from all machines? Is there any network storage device installed on the LAN? Is the network wired or wireless?

Peer-to-peer setup: Presumably you have 3 Windows Users. Is each Windows user represented as users with passwords on all three machines?

Other SQL Applications: Was MS BCM ever installed on the 'server"?

Other Firewalls: Are there other software firewall products installed?

Anti-spware: Is there antispyware on the 'server'?

 

 


 

Graeme Leo
Xact Software Solutions
Auckland, New Zealand
International ACT! Certified Consultant (IACC) and ACT! Custom Developments
graeme@xactsoftware.co.nz
1
Kudos!
08-02-2009 12:01 PM
 
  Reply   Reply  

Re: Unable to connect to server databse
Options    Options  
mike449
Copper Contributor
Posts: 10


mike449

Country: United States

Message 20 of 21

Viewed 2,418 times


Graeme,

 

BINGO! You got it!

Problem was that the SQL ports were being blocked by the Windows firewall. Everything seems to be working now. I can access the db from 2 Windows XP workstations and from the server keyboard. Document 19420 held the key to figuring this out. Now to start playing with ACT! to see if we spring for ACT! 2010 for 5 users.

Thank you very much for taking the time to work this through. I really appreciate it!

 

Mike Rioux

Lynnfield MA USA

2
Kudos!
Accepted Solution
Accepted Solution
08-03-2009 05:05 PM
 
Jump to Page:   1 · 2 · 3  |  Next Page