odbc error 42S02

[umurata]

When I am trying to load from table every things ok
But When I try to execute stored procedure [database].[dbo].[zzzz] with parameters
wfopen(wf=xxx,page=d,type=odbc,timeout=120) D:\Eviews\Dsn\xxx.dsn "Execute [database].[dbo].[zzzz] 'xxx', '04/01/2005', '07/07/2011'" @keep *

gives Odbc error 42s02

Eviews 7.2 and windows 7
What am I doing wrong
Thanks

[EViews Steve]

Try this:

Code: Select all

wfopen(wf=xxx,page=d,type=odbc,timeout=120) D:\Eviews\Dsn\xxx.dsn "{call [database].[dbo].[zzzz]('xxx', '04/01/2005', '07/07/2011')}" @keep *

You basically need to put curly braces around the entire thing, change the 'execute' to a 'call', and finally put parenthesis around the parameters.

Steve

[umurata]

It worked.
Thank you