SQL Explorer

[mpowell_esq]

Greetings,

Using Progress OpenEdge 10.0 How do I configure the SQL Explorer. I Have not used SQL, though I have it sat on my box. I am a HUGE Progress (OpenEdge) fan, and now I am looking at increasing my skills base. How do I configure it so I can use Progress and SQL together ie using the SQL explorer?
TIA

 

[Casper]

Hi,

If you really plan on going to use SQL one way or the other then it's better to set up a secondary broker for SQL connections.
KB 19968

If you've done this then you have to set up permissions for SQL users to acces tables in the database:

See KB 20143 for details on sql92 permissions and security.
Further KB 19170 for granting permissions
KB P95289 for script to grant permissions to all tables.

or: P69145 for quick acces with sql explorer to database.

Some other thing you probably want to do is run dbtool to fix "incorrect" field lengths.: KB P24496

Hope this helps.

Regards,

Casper.

p.s. Sorry but I was to lazy to "tinyurl" these KB articles....

 

[Lee Curzon]

p.s. Sorry but I was to lazy to "tinyurl" these KB articles....

I use an extension for Firefox which lets you right-click on a page to create it's tinyurl and copy it to the clipboard.

Swift and easy.