Facing Login timeout expired When Connecting to Oracle database from Azure data Studio

Question

I am trying to connect to Oracle database from Azure data studio, and im facing the below error.

105082;Generic ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2]. Additional error <2>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired, SqlState: HYT00, NativeError: 0 Additional error <3>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute, SqlState: 01S00, NativeError: 0 Additional error <4>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to, SqlState: 08001, NativeError: 2 .

When I connect from cmd it works fine, ping, telnet everything works fine. Only issue is connecting from Azure data Studio.

Can anyone help in this

Answer 1

Hi @Nawaz ,

Try to enable remote access, install the extension for Oracle, check the login name or password is correct

Please check out this doc:
Quickstart: Use Azure Data Studio to connect and explore Oracle databases

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

User name and Password is Correct and I also i enabled and installed the extension for Oracle.

Still i face the below error

105082;Generic ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2]. Additional error <2>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired, SqlState: HYT00, NativeError: 0 Additional error <3>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute, SqlState: 01S00, NativeError: 0 Additional error <4>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to, SqlState: 08001, NativeError: 2 .

Strange thing is tnsping , remote connection through cmd is working fine. only issue is from azure data studio. can suggest what i am missing please ?

Answer 3

It appears from the error message:
[Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute

You are trying to connect to an Oracle database using the SQL Server ODBC driver. You must install and use the Oracle driver to connect to Oracle servers.

https://www.oracle.com/database/technologies/releasenote-odbc-ic.html