Non-DBO schema in MSSQL [Feb 24]

: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

: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

:raising_hand_man: Rachel Ambler (She/Her) replied

It’s in my new bug report

:person_tipping_hand: o1lab replied

see that, thank you

:person_tipping_hand: o1lab replied

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

:raising_hand_man: Rachel Ambler (She/Her) replied

I don’t, I’m afraid.

:person_tipping_hand: o1lab replied

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

:raising_hand_man: Rachel Ambler (She/Her) replied

The documentation for knex indicates using withSchema

: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

:person_tipping_hand: o1lab replied

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

:person_tipping_hand: o1lab replied

Im looking up knex docs as well

: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.

:raising_hand_man: Rachel Ambler (She/Her) replied

Again, it’s seemingly PostgreSQL specific

Autogenerated from discord


Join NocoDB’s community

DiscordTwitterRedditDocs