When I try to select views in Microsoft Access database in a java application within jdbc:odbc and the sql statement is "select Name from sysobjects where xtype = 'v'" I get this :
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input...
I want to find out the sql strings for creating an query (view ) in Access database and for selecting views ( queries ) from a Access database in Sybaseasa is like this :
" select viewtext from sysviews where viewname = 'name_of_view' "
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.