Non-DBO schema in MSSQL [Feb 24]

Discord-Discussions
1

:raising_hand_man: Rachel Ambler (She/Her) asked

Mssql - despite a bug being closed and referenced in a subsequent issue - I can’t get NoCoDb to use my schema without it falling over. Any ideas anyone? Unable to use non-dbo schema in mssql · Issue #1342 · nocodb/nocodb · GitHub

2

:person_tipping_hand: o1lab replied

The issue was closed since we never heard back on the suggestion :slightly_smiling_face:

Could you please paste in the issue how searchpath was used

3

:raising_hand_man: Rachel Ambler (She/Her) replied

It’s in my new bug report

4

:person_tipping_hand: o1lab replied

see that, thank you

5

:person_tipping_hand: o1lab replied

if you have a node setup, could you pls try connecting with a simple sample js file using knexjs ?

6

:raising_hand_man: Rachel Ambler (She/Her) replied

I don’t, I’m afraid.

7

:person_tipping_hand: o1lab replied

the idea is if it can work with knexjs then we can use that within nocodb

8

:raising_hand_man: Rachel Ambler (She/Her) replied

The documentation for knex indicates using withSchema

9

:raising_hand_man: Rachel Ambler (She/Her) replied

I’m not a Developer by trade, and any I do is a side effect of my job as a Director of Database & BI systems. I’m pretty lost on all things node.js…

10

:person_tipping_hand: o1lab replied

withSchema can be skipped in query builder if connection is fine with a particular schema

11

:person_tipping_hand: o1lab replied

Im looking up knex docs as well

12

:raising_hand_man: Rachel Ambler (She/Her) replied

Unsure if Migrate into Postgres Database Schema other than 'public' · Issue #2799 · knex/knex · GitHub is of any help.

13

:raising_hand_man: Rachel Ambler (She/Her) replied

Again, it’s seemingly PostgreSQL specific

14

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs