sqlschema no output? - Forum - Community Groups - Progress Community

sqlschema no output?

 Forum

sqlschema no output?

  • What would cause sqlschema to not produce output even if I pass it a table name that does not exist.  I can get the output from two other databases but I have a database where sqlschema outputs below.  It will produce the following even when I give it a false table name.

    "OpenEdge Release 10.1B03 as of Sat Nov  3 00:53:18 EDT 2007"

  • The reason the sqlschema produced zero output was becuase my user didn't have permissions.  Although the user could connect to the database via ODBC and execute queries against the database.  SQLschema would not produce any error output on the issue.  It was by running sqldump that I received a permission error.

    My solution was to grant this user dbo permission.