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:

Code: Select all

dbopen EIA
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:

Code: Select all

regcomponents
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