Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mrschafer
Starting Member
2 Posts |
 Posted - 2010-08-18 : 20:18:16
|
| I am using ACT 2010 -- contact management software that runs on the 2005 SQL Express Platform from Sage. The problem is I have both local and remote users and the software can only access a remote database that is on the local network. I have setup a database on our webserver to accomodate all of the users and now need some help making the connection.Can anyone direct me on how to --1. resolve the remote database as local2. keep the SQL Express db synced with the one on the webserver without corrupting and of the records |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-19 : 09:36:34
|
| 1. use sql configuartion manager to create alias2. if you are sending data from web to act, you can use transactional replication -- as long as the version you installed is not express. SQL Express can be subscriber, but not publisher.If both versions are express, you're going to need to write your own custom scripts to synch the tables.NONE OF THIS is supported by ACT I'm sure |
 |
|
|
mrschafer
Starting Member
2 Posts |
Posted - 2010-08-25 : 18:58:27
|
| I got the alias setup, well partially...I have a windows hosting account setup on GoDaddy. I assume I can use this an an alias. Any ideas on what I use for a connection steam?Also, I would like to embed the password into the connection steam if possible. ACT doesn't seem to process the passwords. |
|
|
|
|
|
|
Sage ACT Remote SQL Connection