ODBC 32-bit databases and Eviews 12
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
ODBC 32-bit databases and Eviews 12
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
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 Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: ODBC 32-bit databases and Eviews 12
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
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
Re: ODBC 32-bit databases and Eviews 12
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?
In the meantime, is there a possibility to download a 32-bit version of Eviews 9 Enterprise?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13331
- Joined: Tue Sep 16, 2008 5:38 pm
Re: ODBC 32-bit databases and Eviews 12
We no longer provide downloads for 9 unfortunately.
Follow us on Twitter @IHSEViews
Re: ODBC 32-bit databases and Eviews 12
Would be really great, if you had a solution from within Eviews 12 Enterprise for my problem.
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: ODBC 32-bit databases and Eviews 12
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...
Re: ODBC 32-bit databases and Eviews 12
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.
Re: ODBC 32-bit databases and Eviews 12
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?
Another question: How do I import german letters (ö,ä,ü) into an Eviews Workfile from an ODBC database?
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: ODBC 32-bit databases and Eviews 12
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.
ODBC and import of non-integer numbers
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 Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: ODBC 32-bit databases and Eviews 12
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:
where the two dots in "g..2" tell EViews to treat the comma as a decimal point.
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.
Re: ODBC 32-bit databases and Eviews 12
How do I set Eviews numerics to comma separation instead of period separation?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13331
- Joined: Tue Sep 16, 2008 5:38 pm
Re: ODBC 32-bit databases and Eviews 12
Options->General Options->Spreadsheets->Data Display->Comma as decimal
Follow us on Twitter @IHSEViews
Re: ODBC 32-bit databases and Eviews 12
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)
- 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)
Re: ODBC 32-bit databases and Eviews 12
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.
Another question: how do I import the series from ODBC as characters? My ODBC is read-only.
Who is online
Users browsing this forum: No registered users and 20 guests