Page 1 of 1
DSD.BCIOpenR call to SQLExecDirect failed.
Posted: Mon Mar 12, 2007 6:03 am
by dsonly
i got this message
DSD.BCIOpenR call to SQLExecDirect failed.
what is the expected resson , what i have to do
thanks
Posted: Mon Mar 12, 2007 6:52 am
by ArndW
dsonly - welcome to DSXChange.
In order to help answer your question you should add a bit more information to your post. Even though some can be read from the error message, you should tell us what stage you are using and what you are doing in it. Does the error happen on view data or when running? Do you have other jobs which use this stage successfully?
Posted: Mon Mar 12, 2007 7:42 am
by ray.wurlod
BCI.OpenR suggests ODBC or UniVerse stage. A problem is occurring when trying to "open" (establish a connection) in order to perform a SELECT (or execute a stored procedure that returns rows).
Check that the authentication information is correct. The easiest way to do this is to open the stage and click GetSQLInfo on the stage properties - if this does not generate an error, then connectivity is correct. You then need to look at the job log to get more information. Post full details of error message(s) here - use copy/paste so that it's accurate.