09-10-2008 02:07 AM
When you say "views" are you referring to the OLE DB model? If so the simplest way to get the connection string is to build it in Excel connecting to an external data source and then clicking on properties. This will give you the connection string to the OLE DB views of the ACT! dB. There are some limitations with it noteably the Activities are not presented and it is purely Read Only.
Apparently there is an ACTOleDb object in the SDK but I have not been able to find it in the SDK reference API, if anyone knows can they shed some light onto where I am going wrong?
09-10-2008 09:01 AM
I believe it's ActFramework.CurrentACTOLEDB, which gives you a connection string that will work as long as long as the user is logged in to the framework. It's specifically in ACT! 10.0.1 and later (might be .0.2, but I'm pretty sure it's .0.1)
09-11-2008 08:49 PM
Yes, there is more info on connecting to the ACT! OLE/DB Reporting Provider via the Framework/SDK in Bill's Blog page
this.ACTOLEDB.Text = this.actApp.ActFramework.CurrentACTOLEDB;
It then constructs a connection string such as:
Provider=ACTOLEDB.1;Data Source=C:\Users\chuffman\Documents\ACT\ACT For Windows 10\Databases\Act10Demo.pad;User Id=Chris Huffman;Password=7685259a-b90a-4479-befe-2f8edcbe8ca9
ACT! Development Team