04-20-2010 09:23 AM
04-20-2010 10:51 AM
04-22-2010 10:44 AM
Can you provide help on what the "correct" way to do this would be? I'm going to use a machine to host the site ACT/SQL software and DB. I will make the machine available through the network and always leave it on. I will install ACT on all machines in the office. I want them to hit the DB on the host machine. That host machine will then be synched up with our main site server/database.
I'm trying to test this but everytime I try to open the DB from another machine on the network I get an error message that says "The database could not be accessed, check your network connection to verify that your DB server is connected.
I created the remote database on the host server. Moved the .RDB file to the new laptop after setting up ACT/SQL. Did an unpack and restore. Made sure that it is set to share. The .pad opens fine on the host machine (laptop). Just can't seem to access it from the network even though I can see it.
04-23-2010 06:17 AM
That message can come from several different areas, here is a link to steps for resolving this issue: "The database could not be accessed...
Two of the most common causes are the Firewall exceptions that need to be added and the Network not correctly translating the host computer name, look at those 2 sections first.