5 Replies Latest reply: Oct 10, 2013 4:48 AM by Peter Cammaert RSS

    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

        • Re: QV access ACTWIN database thru OLEDB any hints ?
          Peter Cammaert

          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