10-15-2008 05:52 AM
I am trying to get ACT data into Excel (2003 on XP SP2 (not the server)) through OLEDB. After adding the Data Link properties, I get a message box
'ACT! Oledb Provider for Reporting ERROR' : Cannot CoCraeteInstance(CLSID_IOleDBSecurityImp.
If I click the message box, the following message box appears
'ACT! Data Link Error' : File or Assembly name COledbSecurity, or one of its dependencies was not found.
I have tried: REGSVR32 "D:\Program Files\ACT\Act for Windows\ACTOLEDB.dll"
and used actdiag to rebuild the OLE/DB Report Objects.
I am using ACT! 2009 (11.0) Version 126.96.36.1997
10-15-2008 06:51 AM
This was an issue with 9.01, but I haven't seen it with 11.
Maybe try the regasm function in this ACT! Knowledge Base article - http://tinyurl.com/4a3mht
Let us know if it worked for you... you will need to change the paths for the ACT! 2009 locations
10-21-2008 02:09 AM
Just wondering... do you have COledbSecurity.dll?
Have you tried re-registering that?
10-21-2008 02:20 AM
Registering the dll gives the error '.dll was loaded, but the DllRegisterServer entry point was not found. The file can not be registered.'
Think its a .NET dll, so don't need to register. MaI have also tried dropping it into the assembly, but no joy.
10-21-2008 02:43 AM
It seems that I can connect through VB.NET using:
Dim oleconn As New OleDbConnection(ConnectionString)
without a problem. Maybe the OLE works with .NET only.
I am using Excel 2003 (No VB.NET), so its still a pain
10-21-2008 04:11 AM
10-21-2008 04:45 AM
Yes, that was the first attempt. The second was through VBA in Excel, which gave the same error. The third was code in VB.NET which works (but uses .NET - which is not supported in Excel 2003).
It may be that this version of ACT is .NET compatible only (i.e. The dll did not have COM compatibility).
10-21-2008 05:24 AM
It's supposed to support Office 2003, so I don't think that's it...
If I remember O2003, the OLEDB wasn't installed in a default install. You might re-check that you installed it, and maybe try a Detect and Repair in Excel.
Failing that... maybe try a reinstall of ACT!
You might posting this to the developers area and see if that have any better ideas: