database API

[wilshire]

Hello,

Our institution has developed a database (data warehouse). The language to extract data from databases is similar to SQL.

Can I use Eviews to directly export data from our databases?

Is there any Eviews API which we can use in our database development?

Thanks

[EViews Steve]

I'll assume you are trying to push data from your database into EViews...

There are various methods to do this. First of all, if you can extract your data into a comma delimited text file (or even to Excel), you can read that file into EViews easy enough. Refer to our documentation on how to do this.

If you have an ODBC driver for your database, you can use EViews Enterprise edition to read your data directly using it's built in ODBC support. Look for other forum articles here regarding how to import data from an ODBC data source.

The latest version of EViews (version 7.2) now supports a new API called Database Extensions. If you write a COM object that supports a particular database extension interface that we've defined, EViews can open and query your database via the COM object and treat it similarly to any native EViews database format.

If you'd like more information on that API, I can send it to you...

Steve

[wilshire]

Thanks very much.

Yes, I'd like to have more information about the API. Could you please email it to my email wilshire......@yahoo.com?

[wilshire]

Steve,

Thanks for your past support. Now I am able to extract data from our database server.

I have a few other questions:

1. Our data server has thousands of time series; but when I click "All" after opening the database, I only get 469 series in the window.

2. Often I get this error message:

Database Error: CustomDmxDbLibrary Error "Exception of type 'System.OutofMemoryException' was thrown.

3. Sometimes, I also get this error:

Visual Fortran runtime error:
forrtl:: severe(59), list-directed I/O system error, unit 5,..., dforrt.dll, ...

I would appreciate it if you could provide any possible reasons to solve these problems.

Thanks,

Wilshire

[EViews Steve]

EViews reserves a lot of memory address space for itself when it starts up in case it needs to allocate a lot of memory. If your database extension requires a lot of memory itself, you'll have to reduce the amount used by EViews.

To do this, run EViews and goto the Options->General Options dialog. Click on "Advanced system options" in the left tree. In the section that starts "Memory reserved for Windows, DLL files, device drivers..." you're going to want to increase the default value of 400MB to a higher number to give your DLL more memory. Try doubling it to 800MB, then restart EViews.

Let me know if this resolves all or any of your issues.

Steve