I have a problem extracting data from an Oracle database using OLE DB connection. The extraction runs without any problems from the QV Desktop, but when the job runs from the QVB it returns the following error:
02-02-2015 13:35:21: 0021 OLEDB CONNECT*Provider*XPassword*
02-02-2015 13:35:22: Error: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: The specified module could not be found.
The job is running with the same service account AD-user as the one used to install the driver in the fist place. Furthermor the extraction works fine running from the QV Desktop - and with all users I have tried.
It works if I create an ODBC connection from both QVB, but I would like to avoid using ODBC as it is much slower than OLE DB. Furthermore I have another server where the OLE DB driver works fine when it runs from QVB.
I know there are a lot of posts on this one in the forum, but are they anybody who have fixed the problem in anyway?
Thanks a lot.