I've created db link on oracle database to azure db. The problem is that when i do for example: select * from schema.db_table@azure_db
i have normal result. But when i want to take specific column i have error: 'ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Microsoft][ODBC Driver 18 for SQL Server]SMux Provider: Physical connection is not usable [xFFFFFFFF]. {08S02,NativeErr = -1}[Microsoft][ODBC Driver 18 for SQL Server]Unable to open a logical session {08S02,NativeErr = -1}'
I tried to use uppercases, lowercases, "" etc. Nothing works if i want take one specific column.
Does someone had similar problem?
Related questions 1 ORA-28500: [ODBC Driver 11 for SQL Server]: Attempt to access a column "UtilizaMetrica_DescontoComerci" {42S22,NativeErr = 207} - Column +30 character 6 [Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error (SQL State: 07001; SQL Code: 0) 1 Execute a stored procedure in Oracle from Azure Data Factory v2 Related questions 1 ORA-28500: [ODBC Driver 11 for SQL Server]: Attempt to access a column "UtilizaMetrica_DescontoComerci" {42S22,NativeErr = 207} - Column +30 character 6 [Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error (SQL State: 07001; SQL Code: 0) 1 Execute a stored procedure in Oracle from Azure Data Factory v2 0 How to access SQL Server database hosted on Azure Windows VM using R from Rstudio Connect hosted on AWS ubuntu server? 0 identifier must be declared error when executing stored procedure in VB6 0 Azure Function (python) insert to Azure SQL keep getting an error 0 Connecting to SQL through R in Azure Machine Learning Studio Load 4 more related questions Show fewer related questions
Reset to default
