Community
Showing results for 
Search instead for 
Do you mean 
Reply

Contact Ole DB Grid - Show External SQL Data in ACT!

Tuned Listener
Posts: 4
Country: United States

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

Update: I was also able to make a "Company" version of the control, that works as well as the "Contact" control.  Very useful  Thanks again!

Copper Contributor
Posts: 7
Country: USA

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

Is the source code available somewhere for this controlReplies seem to indicate so, but I am unable to locate it.
Nickel Elite Contributor
Posts: 937
Country: USA

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

Source is located in another thread posted here:
 
Nickel Contributor m4y
Nickel Contributor
Posts: 546
Country: Belgium

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

 

Hello Allen,

Could tell me if this plugin works with ACT2010? If yes, could you provide me a sample of the connection string to connect in the same instance than ACT  (SERVER\ACT7) with the ACTreader password?

Thx in advance.


Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }
Nickel Elite Contributor
Posts: 937
Country: USA

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

From previous posts I believe the control needs to be rebuilt to work in ACT! 2010.

 

The DNS format to connect to any instance of ACT! using ACT! Reader is:

 

Provider=SQLNCLI10;Server=[server ip];Database=msr;Uid=ACTReader; Pwd=[pw]; 

 

But I suggest you consider connecting to ACT! using the OLEDB2 provider if you're using ACT! 2010, data access is much easier and Activities is exposed nicely (where as you may have an issue enumerating all Activities through ACT Reader access).

 

 

Nickel Contributor m4y
Nickel Contributor
Posts: 546
Country: Belgium

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

 

 

Thx for your help, Allen. I will make a try and I'll let you know.

Actually, the goal is to connect to an external instance of SQL Server but I just wanted a sample to help me build the right one. 

But, is it possible to use the OLEDB2 provider in this tool? What is the connection string?


Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }
Nickel Elite Contributor
Posts: 937
Country: USA

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

[ Edited ]

Attached is the Control rebuilt for ACT! 2010 (using IMutableEntity Interface).

 

Please let me know if there are any issues.

 

 

Second posting of this control - corrected bug from first posting

Message Edited by alduet on 06-21-2010 09:25 AM
Nickel Elite Contributor
Posts: 937
Country: USA

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

Here's what the connection string would look like connecting to the OLEDB2 provider. 

 

Provider=ACTOLEDB2.1;Data Source=C:\Documents and Settings\All Users\Documents\ACT\ACT for Windows 13\Databases\ACT2011Demo.PAD;User ID=Chris Huffman;Password=""

Nickel Contributor m4y
Nickel Contributor
Posts: 546
Country: Belgium

Re: Contact Ole DB Grid - Show External SQL Data in ACT!


alduet wrote:

Attached is the Control rebuilt for ACT! 2010 (using IMutableEntity Interface).

 

Please let me know if there are any issues.

 


Allen,

I received this error after adding the component in a tab:
---------------------------
ACT!
---------------------------
Property accessor 'ListComponent' on object 'New Contact OleDBGrid1' threw the following exception:'The method or operation is not implemented.'
---------------------------
OK
---------------------------



And when I try to save the layout:
---------------------------

---------------------------
Error saving layout: Object reference not set to an instance of an object.
---------------------------
OK
---------------------------


Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }
Nickel Elite Contributor
Posts: 937
Country: USA

Re: Contact Ole DB Grid - Show External SQL Data in ACT!

My mistake - I think I built this against ACT! 2011, let me take another look at this.