Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Re: QV access ACTWIN database thru OLEDB any hints ?

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

5 Replies

Re: QV access ACTWIN database thru OLEDB any hints ?

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

Re: QV access ACTWIN database thru OLEDB any hints ?

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

Re: QV access ACTWIN database thru OLEDB any hints ?

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

Re: QV access ACTWIN database thru OLEDB any hints ?

Hi Peter

Thank you very much for your advise.

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

Paul

Re: QV access ACTWIN database thru OLEDB any hints ?

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

Community Browser