how to load a view directly into qlikview from sql server

[trishita]

SQL SELECT *
FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW";

But its showing me error

[sasiparupudi1]

What is the error you are getting?

[sasiparupudi1]

May be try seleting few fields to see if it works

SQL SELECT

F1,

F2
FROM FSCDB.MO_PURCH_SOUNDING_CORRECTION_VIEW

;

[trishita]

do I need to set any variables?

[trishita]

Database not found error

There is no open data connection.

SQL SELECT *

FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW"

[prma7799]

try like this

TableName:

LOAD *;

SQL SELECT *
FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW";

[awhitfield]

So.... have you actually created an ODBC or OLEDB connection to the server / DB?

Andy

[sasiparupudi1]

ODBC CONNECT TO YOURODBC  ;

SQL SELECT *

FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW"

[trishita]

yes and I am logging into the specific database with userid and passwort as well

[awhitfield]

So... did you the "Select" button to create your query?

AFAIK you still haven't confirmed what the error is! What is it?

Andy