I never could get VSG to work in a Datatel account, but I followed the instructions Simon posted to run 'sql' and exit, then call 'SCHEMA_MIGRATE' to create the files. http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg12006.html
After that, when I try to access a file such as STAFF, I get: java.sql.SQLException: You have no privilege on file STAFF Fair enough, so I try to grant privileges: :sql sql> GRANT ALL PRIVILEGES ON STAFF TO PUBLIC; Sorry, you have no privilege on this file! I've tried this as root, and as the owner of all the files in the account. If neither of those users has priveleges on the file, then who does? And which file is it talking about? The STAFF file, or one of the ones that start with SQL? JDBC access to the demo account works, so there must be something wrong in this account, or with the way I'm setting up for SQL access. Any advice? Thanks! -- Wendy Smoak http://wiki.wsmoak.net/cgi-bin/wiki.pl?UniDataJDBC ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
