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.


(farshad) #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


(EvgenyK) #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