[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

Accessing data from Act Professional for Workgroups 8.0?

Hi,

We use Act Professional for Workgroups 8.0 for storing all kinds of data.

I notice that as I have Act installed on my computer, I have a SQL instance called <machinename>\CL7.

Is it possible to get access to this data, so that we can integrate this into our other data management systems?

I've tried connecting to the SQL instance using SQL Server Management Studio, but it doesn't let me login using Windows Authentication. Is there perhaps somewhere in the Act program files that I can find a usable SQL login for our Act installation?

Is there any other way to access the Act data?

We're using C# and Visual Studio 2005.
0
JimR123b
Asked:
JimR123b
  • 5
  • 3
1 Solution
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
The ACT! instance is called ACT7

Do you want to read or write to the ACT! data?

To Read, you can use OLEDB or ODBC. To write, you can only do this via the ACT! SDK

For all the methods, see:
http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html
0
 
JimR123bAuthor Commented:
Sorry, I meant ACT7, not CL7. Not sure where I got that from!
Had a look at the linky, and the only useful information that presentation seems to give me is "requires programming in .Net".
That's exactly what I want to do, but the presentation doesn't seem to give specifics about how in .Net I can get to the data.
If I knew the SQL login, I could probably get the data I need.
I only want to read from Act, not write to.
 
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
If you only want to read from ACT!, then you don't need .Net - you can do this with OLEDB or ODBC

Maybe this will give you some more help:
http://blog.glcomputing.com.au/2009/04/getting-table-structure-and-links-from.html
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
JimR123bAuthor Commented:
I don't know the password, and that article describes how to reset the password, but...
I don't seem to have the ActReader.exe that it refers to, and I'm unsure about changing any passwords, as it suggests. We have many users using our Act database, and I don't want to go and break an existing and working system for many users.
I wonder if I don't have ActReader.exe because our version of Act is so old?
If I could achieve what is shown in this article:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=22989
...I'd be on my way, but I just don't know the login ID and password, and don't want to reset it either.
Surely there's a setting somewhere (perhaps in the registry), that contains some kind of connection string, so that I can extract the password from it?
 
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
ActReader didn't come with ACT! till 11.1

In that KB article JimR123b, have a look at the bottom - there is a link to download the ActReader.zip and the Guide to use it
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
The answer was provided
0
 
JimR123bAuthor Commented:
The guide for ActReader seems to only provide instructions which either use a known password (which I don't have), or to reset the password (which I don't want to do as other users are accessing the system).
 
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
It resets the password and allows you to add your own for the ActReader account which you use for ODBC read/only access to the SQL ... this doesn't effect any user account
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now