Granting Select Rights

[dkirk]

Hi,

I have had a whole heap of problems getting ODBC to work. I have managed to work through most of the problems by searching through these forums, but now I am stuck.

We have Progress 9.1D installed on a RedHat ES3 server. The database has been migrated from a server running Progress 9.0B. I dumped the data from the old server and loaded it on to the new one.

I can connect with ODBC from a Windows client and see the list of tables and the fields in each of those tables. I can't see the contents of those fields though.

So, according to other posts on this forum, I need to grant select rights to public for each of the tables. I have tried to do that from sqlexp but I get permission denied. It seems I need a sysprogress user. I followed P14268 but if I try to log in as sysprogress I get:

PROGRESS Version 9.1D as of Wed May 8 16:47:54 EDT 2002
Connecting user "sysprogress" to URL "jdbc:jdbcprogress:T:localhost:CCL:rstr"... (8920)
null

Now if I try to shutdown the database I get:

Shutdown is executing. (1613)
11:44:25 0 processes still connected. (2262)
11:44:55 0 processes still connected. (2262)
11:48:55 0 processes still connected. (2262)
...

And on, and on. It just won't die.

I would really appreciate some help with this.

Thanks

David Kirk