Page 1 of 1
Fetching from EIA Database: COM library error
Posted: Wed Sep 16, 2015 8:43 am
by jaylamb20
Hello,
I am running EV9 Enterprise on Windows 7 and am struggling to open the EIA database. I added EIA to my db registry and ran the following from the command line:
The following error was immediately returned:
"Database Error: COM library error: 'Object reference not set to an instance of an object'".
I tried the same process on a different machine with a different copy of EV9 Enterprise and I had no issues.
Thoughts?
Re: Fetching from EIA Database: COM library error
Posted: Wed Sep 16, 2015 9:12 am
by EViews Jason
I would make sure you are up to date (select help->EViews update) and then type:
and press enter into the command window.
See if that fixes the problem
Re: Fetching from EIA Database: COM library error
Posted: Wed Sep 16, 2015 9:22 am
by jaylamb20
Hi Jason,
I'm running EV9 in an enterprise setting where I don't have Admin rights, so it may take a bit of time for me to run an EViews Update. For what it's worth, when I run regcomponents it shows both the EIA Online Database and EIA Bulk File as registered.
If just updating doesn't solve the issue, should I follow the EViews prompt to "re-register all components"?
I will let you know when I've run an update and tried again.
Cheers,
-James
Re: Fetching from EIA Database: COM library error
Posted: Wed Sep 16, 2015 10:22 am
by EViews Jason
Select help->about EViews. If you more than 2 months old I would update.
'Regcomponents' is more important, so I would try this first and say yes to 're-register all components'. This however also requires admin privileges.
Re: Fetching from EIA Database: COM library error
Posted: Wed Sep 16, 2015 11:41 am
by jaylamb20
Yep, looks like I'm using a build from July. I will try running regcomponents asap and let you know how it goes.
Thank you for your help.
-James
Re: Fetching from EIA Database: COM library error
Posted: Fri Sep 18, 2015 11:39 am
by jaylamb20
Jason,
I got temporary Admin privileges today and tried your recommended solutions. I updated to the newest build of EV9 (September 14 2015) and ran regcomponents to re-register all components.
Nothing has changed. The EIA Online Database stills shows up as "registered" when I run regcomponents and I still get a COM library error when trying to open the DB.
Do you have other recommendations? Are you able to replicate this error with the most recent EV9 build?
Thank you,
-James
Re: Fetching from EIA Database: COM library error
Posted: Fri Sep 18, 2015 3:46 pm
by EViews Jason
We are seeing different issues with the 32 bit version of EViews but not the 64 bit version.
What version are you using?
Re: Fetching from EIA Database: COM library error
Posted: Mon Sep 21, 2015 7:07 am
by jaylamb20
Jason,
Here is my environment:
Eviews: EV9 Enterprise (64-bit), September 14 2015 Build
OS: Windows 7 Professional (64-bit)
To reiterate...I am running EV9 Enterprise (most recent build) on Windows 7 Home on my home laptop, and have not had the same issues. From home, I'm able to access the EIA databases as expected without error.
Thank you for your help,
-James
Re: Fetching from EIA Database: COM library error
Posted: Mon Sep 21, 2015 9:40 am
by EViews Jason
Can you list the versions of Microsoft .NET you have installed on your non-working computer? If you open the C:\Windows\Microsoft.NET\Framework directory on your computer, you will see a list of directories starting with v*. Please list those directories.
Re: Fetching from EIA Database: COM library error
Posted: Mon Sep 21, 2015 10:55 am
by jaylamb20
In descending order by "date modified":
v4.0.30319 - Sep 2015
v2.0.50727 - Jul 2015
v3.5 - Dec 2013
v3.0 - Nov 2010
v1.0.3705 - Nov 2010
v1.1.4322 - Jul 2009
Re: Fetching from EIA Database: COM library error
Posted: Tue Sep 22, 2015 8:23 am
by EViews Jason
Email us at
support@eviews.com and we will either call or webex into your computer to see what is going on.
Re: Fetching from EIA Database: COM library error
Posted: Tue Sep 22, 2015 3:30 pm
by jaylamb20
Thank you. I have sent an email and I look forward to speaking with an EViews rep soon.
Whenever we resolve this, I will return to the thread and post a solution for other users.
-James
Re: Fetching from EIA Database: COM library error
Posted: Mon Sep 28, 2015 10:00 am
by jaylamb20
Just to close this off for new readers coming to the forum...
Mine was an edge case, and a fix will be included in the next patch of EV9.
Thanks to Jason and the EViews team!
-James