Page 1 of 1

odbc error 42S02

Posted: Fri Jul 08, 2011 6:20 am
by 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

Re: odbc error 42S02

Posted: Fri Jul 08, 2011 8:37 am
by 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

Re: odbc error 42S02

Posted: Fri Jul 08, 2011 3:13 pm
by umurata
It worked.
Thank you