# Schema Modeler - Connections Manager Table Explorer Broken

**URL:** https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385
**Category:** Data Abstract
**Created:** [May 15, 2018, 7:15pm UTC](https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385 "2018-05-15T19:15:46Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![kbripleyindcom](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/k/3be4f8/32.png) [@kbripleyindcom](https://talk.remobjects.com/u/kbripleyindcom)
#### Post date: [May 15, 2018, 7:15pm UTC](https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385/1 "2018-05-15T19:15:46Z")

</div>

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](https://talk.remobjects.com/uploads/default/original/2X/3/3e1eab07489e4d42ace91649f188e5a5ac847cdb.jpg)

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.

---

<div class="post-metadata">

### Author: ![antonk](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/a/a5b964/32.png) [@antonk](https://talk.remobjects.com/u/antonk)
#### Post date: [May 15, 2018, 9:02pm UTC](https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385/2 "2018-05-15T21:02:56Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![kbripleyindcom](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/k/3be4f8/32.png) [@kbripleyindcom](https://talk.remobjects.com/u/kbripleyindcom)
#### Post date: [May 17, 2018, 3:04pm UTC](https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385/3 "2018-05-17T15:04:24Z")

</div>

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

---

<div class="post-metadata">

### Author: ![EvgenyK](https://talk.remobjects.com/user_avatar/talk.remobjects.com/evgenyk/32/16_2.png) [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [May 18, 2018, 8:58am UTC](https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385/5 "2018-05-18T08:58:17Z")

</div>

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

---

<div class="post-metadata">

### Author: ![kbripleyindcom](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/k/3be4f8/32.png) [@kbripleyindcom](https://talk.remobjects.com/u/kbripleyindcom)
#### Post date: [May 18, 2018, 10:02am UTC](https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385/6 "2018-05-18T10:02:00Z")

</div>

That worked. Thanks.

---

<div class="post-metadata">

### Author: ![farshad](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/f/bbe5ce/32.png) [@farshad](https://talk.remobjects.com/u/farshad)
#### Post date: [June 2, 2018, 9:13pm UTC](https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385/8 "2018-06-02T21:13:26Z")

</div>

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

---

<div class="post-metadata">

### Author: ![EvgenyK](https://talk.remobjects.com/user_avatar/talk.remobjects.com/evgenyk/32/16_2.png) [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [June 4, 2018, 8:42am UTC](https://talk.remobjects.com/t/schema-modeler-connections-manager-table-explorer-broken/16385/10 "2018-06-04T08:42:17Z")

</div>

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
