Dear Friends,
Now I have ODBC connections to several SQL server database, Using Management Console I have built some libraries and "successfully" registered with both tables and views. The displayed libname statement is as following:
LIBNAME T_SQL ODBC DATASRC=SQLDATA1 SCHEMA=DBO USER=XXX PASSWORD=XXX;
EG opens tables fine, but when try to open views (I can still see them), I got:
[Error] File SQLDATA1.VWXXX does not exist.
[Error] The metadata for the table/view SQLDATA1.VWXXX does not exist.
Now is the puzzling part: if I run the above libname statement using either Base or EG to define a library, views can be opened without issue. That hints pre-assigned option may work, but I want to avoid using pre-assigned setting unless it is absolutely necessary. So is it? is this the case that Meta engine can't have it covered?
Thank you in advance!
Haikuo