SQL Explorer Progress Version 9.1C

S

sagrjty

New Member
Hi,

I am quite new to Progress, need advice from all the experts here.

I am trying to create a view in Progress (Syteline 6) for some reporting using SQL Explorer. As there are more than 1 databases in different ports, how do I connect to 2 or more databases at same time?


Is it possible to create view in multi-user mode? I created views previously but if users are connected to a particular database, I will get an error message:

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210017
[JDBC Progress Driver]:Failure to acquire exclusive schema lock for DDL operation. (7872)


Thanks
 
Answer found

Hi all,

Found the answers to my questions in Progress Software Knowledge Center.

For the possibility of querying two databases in SQL Explorer. Please refer to Solution ID: P25002

For possibility of creating view in multi-user mode, please refer to
Solution ID: P26368
 
You must log in or register to reply here.
Back
Top