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

Nawaz 1 Reputation point
2022-11-21T07:51:44.593+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. YufeiShao-msft 7,056 Reputation points
    2022-11-21T09:09:21.033+00:00

    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.

  2. Nawaz 1 Reputation point
    2022-11-21T10:26:49.85+00:00

    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 ?

    0 comments
  3. Tom Phillips 17,716 Reputation points
    2022-11-22T13:47:06.653+00:00

    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

    0 comments