Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT Premier SQL questions

New Member
Posts: 1
Country: USA

ACT Premier SQL questions

I need to be able to install ACT using SQL 2008 instead of Express.  This is supported in Premier, correct?

 

Also, once the table are on a server, can you run inserts to the ACT tables?  We have some external accounting and LDAP tables that we want to synch to ACT.  Curious is this can be accomplished???

 

Thx

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT Premier SQL questions

Yes you can use SQL 2008 Standard... you need to manually create the ACT7 instance as per this ACT! Knowledge Base article -

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2703...

 

No, you cannot write directly to the database. You need to do this via the ACT! Framework. See:

http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html

Bronze Elite Contributor
Posts: 2,545
Country: New_Zealand

Re: ACT Premier SQL questions

It could be done using an API for ACT! refer API for ACT!  Database integrity is assured as it uses the ACT! SDK.

Graeme Leo
Xact Software - consultants and developers
Follow us on Twitter and check out our Blog