Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT OLE Data Provider Error

New Member
Posts: 6
Country: United Kingdom

ACT OLE Data Provider Error

Hi,

 

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 11.0.0.367

 

 

 

 

 

 

 

 

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT OLE Data Provider Error

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

New Member
Posts: 6
Country: United Kingdom

Re: ACT OLE Data Provider Error

Hi,

 

I am afraid the error is still there. I get the same error opening a connection using the the provider 'ACTOLEDB.1' in VB.

 

 
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT OLE Data Provider Error

Just wondering... do you have COledbSecurity.dll?

 

Have you tried re-registering that?

New Member
Posts: 6
Country: United Kingdom

Re: ACT OLE Data Provider Error

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.

 

 

New Member
Posts: 6
Country: United Kingdom

Re: ACT OLE Data Provider Error

Hi

 

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

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT OLE Data Provider Error

New Member
Posts: 6
Country: United Kingdom

Re: ACT OLE Data Provider Error

Hi,

 

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).

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT OLE Data Provider Error

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:

http://community.act.com/sage/board?board.id=Pub_Dev