Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV access ACTWIN database thru OLEDB any hints ?

Hi All

I have below code working fine on my desktop computer :-

CONNECT TO [Provider=ACTOLEDB.1;Data Source=C:\Documents and Settings\admin\My Documents\ACT\ACT for Windows 10\Databases\TID2011.pad;User ID=admin;Persist Security Info=True] (XPassword is JMSOfQRMNLacGJD);

when i using my note book to access the ACT WIN database , i am not able access the data file , i get the error msg :-

OLEDB connection failed

SQL SELECT "CONTACT OPPORTUNITY CONTACTID",

'TID' as SOURCE_OPP,

  "CONTACT OPPORTUNITY CONTACTID" as ID10,

  "CONTACT OPPORTUNITY OPPORTUNITYID" AS ID99,

    "STAGE STAGEID"

FROM dbo."VRP_CONTACT_OPPORTUNITY"

I like to know , does it mean that i need to install OLEDB driver into my note book inorder to access the database ?

Paul

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Well, in general OLEDB/ODBC providers are installed together with the application. Indeed, there is no mention of a separate OLEDB package on the Act! web site.

It may be so that Act! is an application with local data files only, and you need a real RDBMS to access Act! data remotely. But I'm not an expert on Act! details.

  • Check whether Act! uses a real RDBMS, or just local data files. In the latter case you probably cannot access Act! data from a remote machine.
  • If Act! is using an RDBMS, check whether the Act! installer allows you to install an OLEDB driver separately as part of the installation process. Usually the installation process provides a customized installation selection window where you can choose what to install.

Good luck,

Peter

View solution in original post

5 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Of course you have to. An OLEDB CONNECT is a generic statement that interfaces to a remote DB through the driver you specificy with the parameter "Provider". No driver, no connection.

It's almost like connecting thru ODBC except that the OLEDB connect specifies all DB details inside the statement, while an ODBC CONNECT relies on a DB definition outside the QV environment.

BTW Usually installing an OLEDB driver is a simple task. Download the software, run the installer, done.

Best,

Peter

Not applicable
Author

Hi Sir

I have notice that it is like what you said , i lack of install driver .

ACT! OLE DB Provider for Reporting

I have search hi and lo from ACT saga web site , unable to find it . you know where i download this driver ?

Paul

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Well, in general OLEDB/ODBC providers are installed together with the application. Indeed, there is no mention of a separate OLEDB package on the Act! web site.

It may be so that Act! is an application with local data files only, and you need a real RDBMS to access Act! data remotely. But I'm not an expert on Act! details.

  • Check whether Act! uses a real RDBMS, or just local data files. In the latter case you probably cannot access Act! data from a remote machine.
  • If Act! is using an RDBMS, check whether the Act! installer allows you to install an OLEDB driver separately as part of the installation process. Usually the installation process provides a customized installation selection window where you can choose what to install.

Good luck,

Peter

Not applicable
Author

Hi Peter

Thank you very much for your advise.

side topic , may i know you are specialize in ACT ?

Paul

Peter_Cammaert
Partner - Champion III
Partner - Champion III

No problem. Please mark your question as answered to close the discussion.

No I'm not an Act! specialist. I just used to advise SMBs on topics like CRM-applications a long time ago but not specifically Act!.

Best,

Peter