OK I just purchased ACT version 7.0 Premium for workgroups. All the literature from ACT says that this version runs on SQL server, It even came with it's own version of SQL standard licensed for use with ACT. I have had it installed for about 24 hours now and the more I learn the more I am conviced that it isn't using SQL Server at all and is entirely dependant on MSDE. So my question is simply this, is there some way I can tell if it is using the SQL server? If so can I tell what is on SQL Server and what is on MSDE?
Here is some additional info I have come accross:
Fact #1 - in the 1st open beta of this product if ACT was installed on a preexisting SQL server the user could attach the act databases from within the Enterprise Manager with no ill effects. In the very next beta release (and ever since) if a user did this it would break the database so it would no longer work with the ACT software.
My thoughts on Fact #1 - If ACT was truly hosting the data IN SQL server why would the user neeed to attach the database at all? shouldn't it just be listed under databases?
Fact #2 - The only way ACT is providing access to their data from outside of ACT is through OLEDB ( http://www.act.com/support/technicalsupport/pf2005/2005sdk/index.cfm
My thoughts on Fact #2 - If it were truly hosted on SQL Server wouldn't I be able to access the data through ADO?
Fact #3 - When a new ACT database is created by the user it creates the following 3 files: filename.pad, filename.adf, filename.alf. The ADF file contains the data (not sure if this is ALL the data or not), the ALF file is a log file and the PAD file contains the connection string:
<ACT2005Database name="EricTest2" host="USA-ERIC" location="C:\Documents and Settings\ericw\My Documents\ACT\ACT for Win 7\Databases" type="Sql" />
My thoughts on Fact #3 - I have been told by ACT tech support that if I create a database in ACT from a client PC it creates those files and hosts them via MSDE (the above connection string is from a client created database), but if I create a database in ACT from the machine with the SQL server installed on it it will host the data from the SQL Server. Now other than the host name being different the connection string isn't any different when created on the server. Also, the database creation process looks identicle whether it was done on the server or a client and it produces the same 3 files.
Fact #4 - According to ACT tech support if someone emails me an ACT database all I have to do is open it from within ACT and it will be all ready to go. If I open it from a client it will be accessed via MSDE if I open it server it will be hosted by and accessed through SQL server.
My thoughts on Fact #4 - Damn thats some pretty slick and intuitive software! aka sounds like BS to me.
Sorry for the long post but I am pretty steamed at the moment and would really love to know what kind of crap ACT is slinging at me.
Thanks in Advance, E