sqlschema no output?

Posted by Mark.Ward on 24-Jan-2011 14:25

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"

All Replies

Posted by Mark.Ward on 25-Jan-2011 13:01

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.

This thread is closed