ODBC 32-bit databases and Eviews 12

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

ODBC 32-bit databases and Eviews 12

Postby centroid » Thu Feb 25, 2021 8:01 am

Hi
My system ODBC databases are all in 32-bit. I have Eviews 12 enterprise version installed. It is the 64-bit version. Do I have to install a 32-bit version of Eviews in order to access my system ODBC 32-bit databases? The system ODBC are installed but I currently do not see them from Eviews 12 (import foreign data as workfile - ODBC databases - system sources). Where can I download Eviews 12 in 32-bit?
Thanks

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: ODBC 32-bit databases and Eviews 12

Postby EViews Steve » Thu Feb 25, 2021 10:25 am

You can't use a 32-bit ODBC driver from EViews 64-bit. And unfortunately, EViews 12 is currently only available as a 64-bit application.

We don't have any plans on releasing EViews 12 32-bit, but we can look into what it would take to allow EViews 12 64-bit to support 32-bit ODBC drivers - though this will take some time. If you can update your drivers to be 64-bit, that would be the quickest solution. Or if you still have an older version of EViews 32-bit, I would suggest using that version for now.

Steve

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

Re: ODBC 32-bit databases and Eviews 12

Postby centroid » Thu Feb 25, 2021 11:27 am

It would be great if you could enable Eviews 12 Enterprise to access 32-bit ODBC.
In the meantime, is there a possibility to download a 32-bit version of Eviews 9 Enterprise?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13306
Joined: Tue Sep 16, 2008 5:38 pm

Re: ODBC 32-bit databases and Eviews 12

Postby EViews Gareth » Thu Feb 25, 2021 11:30 am

We no longer provide downloads for 9 unfortunately.
Follow us on Twitter @IHSEViews

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

Re: ODBC 32-bit databases and Eviews 12

Postby centroid » Thu Feb 25, 2021 1:40 pm

Would be really great, if you had a solution from within Eviews 12 Enterprise for my problem.

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: ODBC 32-bit databases and Eviews 12

Postby EViews Steve » Thu Feb 25, 2021 2:18 pm

Out of curiosity, which ODBC 32-bit drivers are you using? For which databases? I'm kinda surprised there aren't 64-bit versions available so I'd like to know...

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

Re: ODBC 32-bit databases and Eviews 12

Postby centroid » Thu Feb 25, 2021 2:47 pm

I am not sure, I use also another application with these 32-bit ODBC databases, as well. I have to ask our IT adviser. I remember we had difficulty installing the 64-bit versions of the drivers.

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

Re: ODBC 32-bit databases and Eviews 12

Postby centroid » Fri Feb 26, 2021 2:05 am

In the meanwhile I found an old download of 32-bit Eviews 9 Enterprise.

Another question: How do I import german letters (ö,ä,ü) into an Eviews Workfile from an ODBC database?

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: ODBC 32-bit databases and Eviews 12

Postby EViews Steve » Fri Feb 26, 2021 8:41 am

Ascii characters that are not in the current language setting are not supported in EViews. That means if you're using EViews on an English language OS, you won't be able to see the German characters properly. However, if you're running EViews on a German language OS, and those characters are part of the normal German ASCII table, then you'll see them properly since EViews uses whatever ASCII table is currently the main one. Of course, this also depends on whether or not your ODBC driver supports those characters as well.

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

ODBC and import of non-integer numbers

Postby centroid » Sat Feb 27, 2021 4:50 pm

I am importing also non-integer numbers from an ODBC database. In the preview in Microsoft query it looks all fine, but after importing the respective columns, the numbers somehow get crunched into something extremely big, seemingly of integer type. How can I solve this problem?

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: ODBC 32-bit databases and Eviews 12

Postby EViews Steve » Sun Feb 28, 2021 8:29 am

When you go thru the EViews import wizard, make sure those columns are marked as the correct data type. Also, it might be an issue with how EViews is parsing the decimal point (comma or period?) in your numeric values. If your data uses a comma instead of a period, make sure EViews is set to that before doing the import. Or perhaps this is a region setting in your ODBC DSN?

Another suggestion is to bring in the series as character data, then do an explicit conversion inside of EViews to numeric like this:

Code: Select all

series nok_kg_val=@val(nok_kg,"g..2")

where the two dots in "g..2" tell EViews to treat the comma as a decimal point.

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

Re: ODBC 32-bit databases and Eviews 12

Postby centroid » Sun Feb 28, 2021 4:25 pm

How do I set Eviews numerics to comma separation instead of period separation?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13306
Joined: Tue Sep 16, 2008 5:38 pm

Re: ODBC 32-bit databases and Eviews 12

Postby EViews Gareth » Sun Feb 28, 2021 5:30 pm

Options->General Options->Spreadsheets->Data Display->Comma as decimal
Follow us on Twitter @IHSEViews

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

Re: ODBC 32-bit databases and Eviews 12

Postby centroid » Mon Mar 01, 2021 2:11 am

I could narrow down the problem as follows and summarize what I have done so far:
- my data series in ODBC has two additional decimal numbers after the comma (something like 90.00 or 90.50 for example)
- it is correctly displayed in MS Query whilst in the Eviews import wizard
- it is considered as numeric by Eviews whilst importing ("num")
- After the import the series contains the same number all along the series, and a specifically a number like 1.345345e35, an extremely high number.
- setting to comma separation both in windows and in Eviews did not help. After setting to comma separation in Windows 10, MS Query also displayed commas in the series when previewing the series.
- I am not allowed to make changes to the ODBC database (read-only)

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

Re: ODBC 32-bit databases and Eviews 12

Postby centroid » Mon Mar 01, 2021 7:10 am

Unfortunately, the numbers are still not imported correctly.

Another question: how do I import the series from ODBC as characters? My ODBC is read-only.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 26 guests