Showing results for 
Search instead for 
Do you mean 

Database views

Tuned Listener
Posts: 11
Country: India

Database views

Hi all


How can we use database views?


Can anyone provide me a sample for it?




New Member
Posts: 2
Country: United States

Re: Database views

Good luck trying to get any info out of the database.  It is locked from accessing it directly.  The only way that I have been able to extract data is through writing .NET functions.
Tuned Listener
Posts: 11
Country: India

Re: Database views

can we use views using .net functions ??


because in ACT Database model i have seen that there are views.

Bronze Elite Contributor
Posts: 2,117
Country: United_Kingdom

Re: Database views

Hi ck,


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?




Vivek Gargav
Caldere Associates Ltd.
My Blog
Nickel Super Contributor
Posts: 352
Country: Canada

Re: Database views

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)




Len Kamerman
ACT! Certified Consultant

Act E-mail Marketing Trainining Course:
Copper Super Contributor
Posts: 138
Country: United States

Re: Database views

Yes, there is more info on connecting to the ACT! OLE/DB Reporting Provider via the Framework/SDK in Bill's Blog pageSmiley Wink


Basically it's:

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

Bill Blakey
ACT! Development Team
Sage Software