Schema Modeler - Connections Manager Table Explorer Broken


(kbripleyindcom) #1

After updating to the latest build:
Data Abstract Schema Modeler RemObjects Data Abstract Framework
Version 9.4.107.1363 Build date 2018-03-21

Berlin, Ado, mssql 2012

Connections Manager will no longer show tables and structures per:

image

The connection is valid and retrieves queryies and passes the test button. No matter how many times I refresh the tables will no longer be available for viewing and such.


(antonk) #2

Hello

Please specify the full connection string used (replace username, password and hostname/database name with dummy values if needed). Also please check that the user mentioned in the connection string has the access rights required to access database schema info.


(kbripleyindcom) #3

ADO?AuxDriver=SQLOLEDB.1;Server=192.168.x.xxx;Database=RipleyMrpSQL;UserID=xxxx;Password=xxxxxx;CommandTimeout=180;


(EvgenyK) #5

try to add Schemas=1; to your connection string. it is used for displaying objects from all schemas


(kbripleyindcom) #6

That worked. Thanks.