Community
Showing results for 
Search instead for 
Do you mean 
Reply

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

Nickel Elite Contributor
Posts: 937
Country: USA

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

I reposted fixed control to same thread above.
Nickel Contributor m4y
Nickel Contributor
Posts: 546
Country: Belgium

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

Allen,

 

Yeah, it works now with last build for ACT2010. Thanks a lot.

It workd with your OleDB string but not with the first one you gave me:


alduet wrote: 

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];

 

 


Nothing appears with this above...

 

 

So I had a look in the string used when I call for external data in a excel sheet and copied that in the component's connection string :

Provider=SQLOLEDB.1;User ID=ACTREADER;Password=MyPassword;Initial Catalog=ACT2010Demo;Data Source=COMPUTER\ACT7;

 and it works too...

What do you think about this connection string? Any advice/remark?

TIA

 

 


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!

The connection string you specify is a better option - it uses the SQL OLEDB driver - the one I had posted is for the SQL Native driver.  I thought the control was smart enough to parse either, but looking at the code it is expecting an OLEDB connection string.

 

Thanks!

Nickel Contributor m4y
Nickel Contributor
Posts: 546
Country: Belgium

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

OK Allen, thanks for your advice.

 

Two more questions:

1. Is the source you published in the other topic still up to date? Or could you post the source for the component you posted in previous message?

2. Is it possible to edit and remain each column width?


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!

The new control is the same source with the changes to this .cs file only.

 

 

Nickel Elite Contributor
Posts: 937
Country: USA

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

[ Edited ]

2. Is it possible to edit and remain each column width? 

 

Are you referring to allowing users to resize column width?

 

If you look at the source code of this control Pierre has written a bespoke control (UCGridView) to render the control.  I presume he wrote this as the DataGridView in .Net is tough to simply pass a SQL connection and statement as properties.  There are other 3rd party .Net controls that do allow this (SalesLogix has a neat little control that allows this as well).

 

You could edit the source and compile a new version of this control that uses one of these 3rd party controls.  Alternately you could attempt to add to this control's properties and add something like AllowUserChangeColumnWidth property.  The DataGridView control has this property so you could look at that control to get an idea how to do this.

 

As neat as this control is I don't get much time to play with it or modify it often so I am unaware of an easier way to do this for this control.

 

Regards,

Message Edited by alduet on 06-21-2010 02:29 PM
Nickel Contributor m4y
Nickel Contributor
Posts: 546
Country: Belgium

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

OK, thanks for all your answers Allen.

Do you think there could be performances issues with very large DB? I have a customer who would use it on 5 tabs in a database which should be contain 400,000 contacts (but only between 10 and 20 concurrent users).

Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }
New Member
Posts: 1
Country: Poland

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

[ Edited ]

I would like to ask if there is any chance for this application to work in the window of companies for act 2008 (10)?

Tuned Listener
Posts: 10
Country: United Kingdom

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

I'm going to ask a potentially stupid question; I've been playing around with the control to test various things.  I had to remove it from the toolbox at one stage due to some other testing issues, but now when I try and add it back into the 'custom' list I just don't see the control listed.  

 

It's in the 'tools' directory as before, but for some reason ACT just seems to ignore it (however, if I have ACT open and try and delete the .DLL Windows will tell me that the file is in use, so ACT must at least be aware that it's there).

 

Any ideas / pointers?

 

Thanks.

 

Ian.

 

Tuned Listener
Posts: 9
Country: Canada

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

Hi ,

 

I just download the source code (Contact Ole DB Grid) and I am using ACT!2010 Premium.

 

Where can I change (in the code?):

SQL and fields

String connection

 

Thanks