01-04-2021 12:13 PM - edited 01-04-2021 12:15 PM
Running ACT21update4 on Win10/64 and Excel 2019/64. Trying to get an ole connection to the database. I follow these instructions in Excel: https://help.act.com/hc/en-us/articles/360024246694-How-To-Create-An-ODBC-Connection-For-Use-With-Th... with changes to adapt to the later Excel version. The 'connection test' works fine, but when selecting a table, I get
DataSource.Error: An error happened while reading data from the provider: 'Value cannot be null.
Parameter name: pUnk'
no matter what table I select.
01-06-2021 08:10 AM - edited 01-06-2021 08:16 AM
Try rebuilding the ODBC engine
Type at the start button ACTDIAG.EXE
Follow instructions from section 16 rebuilding OLE / DB2
Just a further thought, from memory I cannot remember if this function is fully functional in the standard ACT version, I know it is in the Premium one. Just a nag at the back of my mind so you might want to have a dig around to make sure this OLE DB2 feature is fully enabled.
01-08-2021 06:31 PM
OK, tried this, but no go.
Apparently the ActReader application is Premium only, but Act! Pro ought to be ok for direct OLE access per this link https://help.act.com/hc/en-us/articles/360024247834-How-to-Create-an-OLE-DB-2-0-Connection-in-Act-. Again the 'test connection' works, but once I try to load a table it bombs out.
01-12-2021 05:25 AM
Yes, same result. Attached a screenshot.
One further question, I have my machine set up for 64 bit, but ACT is running 32 bit, would this be a problem? And if so, that's crazy since everyone runs 64 bit now...
01-12-2021 05:53 AM
ACT V22 is supposed to be 64 bit compatible with office but there many observations from users with strange problems where moving Office to 32 bit has solved their problems so just might be re-installing office as 32 bit but you then have to re-install ACT for Office integrations to re-connect.
01-12-2021 06:34 AM - edited 01-12-2021 06:35 AM
Yeah, I don't really use the Integrations, but reinstalling Office sounds like a big pain... I'd like to know this would work before doing it.
01-16-2021 08:01 AM
Have you tried a direct SQL connection? It bypasses the restrictions of OLE DB2 access to tables so if you want instructions will email them to you if you send me a private message as would not want to publish them here.