OE Broker fails to start SQL server - Connection profile Pro

Posted by christophe.mabileau on 20-May-2009 09:54

I'm trying to create a connection profile to Progress database from Architect. If the host is my PC (localhost) it's ok but not on the server.

I have this error message "OE Broker fails to start SQL server".

The database and the broker are running.

OpenEdge RDBMS - Forum

All Replies

Posted by christophe.mabileau on 17-Jun-2009 05:04

My connection profile is ok but I can't "Preview" the data from a table (Access denied) and I can't create a SQL req. Anybody knows why?

Posted by Thomas Mercer-Hursh on 17-Jun-2009 11:42

At the original install, did you specify to enable both ABL and SQL?  If you look in the database log file, does it say that SQL access is enabled?

Posted by Admin on 17-Jun-2009 12:18

When the connection is o.k., but a select fails (the Preview) I'd assume it has something to do with the rights on the table.

Can you (or somebody else) GRANT DBA to your user account?

Posted by Thomas Mercer-Hursh on 17-Jun-2009 12:45

This http://www.oehive.org/node/954 should give you an idea of how to set those, if you haven't already.

Posted by christophe.mabileau on 29-Jun-2009 08:59

I found a solution for my pb. I created databases from Architect (DataAdministration) and I loaded my old databases to the new ones.

Thanks

This thread is closed