SQL Table Editor - Query - External DataBase
SOURCE: ONESTREAM CHAMPIONS
Hi Team,
do we need to put some specific settings to connect the External DataBase… when we are connecting it via SQL Table Editor.
i am getting the below mentioned ...
Forum Discussion
Darpan
Suggestion based on the thread… Create an additional external DB connection as ODBC or OLE DB based on the current connection. For example, if the external DB connection is currently, ODBC create OLE DB and if ODBC create OLE DB. I suggest this because at one client the external connection stopped working one day unexpectedly and switching the connection type resolved the error. Also, if you execute SELECT * FROM SYS.SYSOBJECTS with the current connection do you get results.
Terry
Understood Terry,
Let me speak to One Stream team on the same , we do not have access to create New External DB Connection.
but as per my understanding creating new DB connection and changing the Default Schema should resolve this issue.
this issue is not per OLE DB or ODBC.
let me try both the options and confirm.
Regards
Darpan
