Invalid object name 'information_schema.schemata
Issue #72
resolved
When connecting to SQL server the Invalid object name 'information_schema.schemata is appearing I've done the test connection and it run fine.
Test Result Connection succeeded. Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) 1620 tables + 373 views
when I try to export the metada in a local file the system gives not been able to export your metadata info.
Comments (3)
-
repo owner -
repo owner We just changed all INFORMATION_SCHEMA names to upper cases, which should fix the error. Download the code in about two days, to verify.
-
repo owner - changed status to resolved
- Log in to comment
it looks like a collation problem, see https://github.com/tds-fdw/tds_fdw/issues/146
We’ll fix it. Thanks.