Schema Modeler - Connections Manager Table Explorer Broken

Data Abstract
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.

1 Like
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.

3

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

5

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

6

That worked. Thanks.

8

Hi,

I had exactly the same problem. Adding "Schemas=1; " resolved it. I recommend adding it by default to ADO driver parameter list because it is difficult to figure it out in without the prior knowledge.

Thanks

10

by historical reasons, only SQLOLEDB.1 auxdriver hasn’t Schemas=1 parameter.
all others ADO/MSSQL auxdrivers have Schemas=1.

I’ll update ADODriver and it will show Schemas parameter in list of available parameters