Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Good luck,
Peter
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
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
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.
Good luck,
Peter
Hi Peter
Thank you very much for your advise.
side topic , may i know you are specialize in ACT ?
Paul
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